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

The 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.

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

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.

Did it work?

[DELETED]

[DELETED]

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

[DELETED]