7 replies
Hey Warriors,

How do I get rid of all the quotes surrounding the keywords in excel on cell A1?

ie: " keyword" to keyword

I want to clean or filter out the quotes

thanks
#excel
  • Profile picture of the author jemmachris
    Originally Posted by AllThingsArePossible View Post

    Hey Warriors,

    How do I get rid of all the quotes surrounding the keywords in excel on cell A1?

    ie: " keyword" to keyword

    I want to clean or filter out the quotes

    thanks

    Hi,

    This is how I do it.... I'm not sure if there's an easier way but this works.

    In B1 use the formula

    =RIGHT(A1,LEN(A1)-1) ----- this removes the left hand "

    In C1 use the formula

    =LEFT(B1,LEN(B1)-1) ----- this removes the right hand "


    Hope this helps!

    Jemma
    {{ DiscussionBoard.errors[5514415].message }}
  • Profile picture of the author rainso0
    The Data-> Text to Columns-> Finish worked!!!

    I won't bother to post the worksheet, but doing find/replace with the single quote did not work. Excel did not find the single quote as it is not seen as part of the contents of the cell.
    Signature
    {{ DiscussionBoard.errors[5516417].message }}
  • Profile picture of the author webpeon
    if its only 1 cell why would you complicate things and not just click next to the " and press backspace, just seems strange to me...

    alternatively if you have a bunch of " you need to get rid of you could always copy/paste to notepad, edit/replace then repaste back into excel
    Signature
    Web 2 Mobile
    The Future of The Web
    {{ DiscussionBoard.errors[5517235].message }}
  • Profile picture of the author tiptopwarriors
    Originally Posted by AllThingsArePossible View Post

    Hey Warriors,

    How do I get rid of all the quotes surrounding the keywords in excel on cell A1?

    ie: " keyword" to keyword

    I want to clean or filter out the quotes

    thanks
    hahaha

    just select the whole column and press Ctrl+F >select "replace" tab> in "find what:" field type quotes or anything you want to remove> "replace with:" field leave blank> press replace all.
    If you still have difficulty I'll post pictures for you.
    {{ DiscussionBoard.errors[5532993].message }}
  • Profile picture of the author mortenmatras
    Did it work?
    {{ DiscussionBoard.errors[5562230].message }}
  • Profile picture of the author shantipropertie
    use replace function to remove the codes surroindings the keywords for eg. replace:" with space

    i.e. Cntrl F -> Replace -> put ( " ) in Find What -> Replace with: (keep empty)

    Hit Replace or Replace All
    {{ DiscussionBoard.errors[5590964].message }}

Trending Topics