Delete Leading Apostrophes in text fields

[John Underwood]

Hi,

I've created a microsoft excel worksheet from access. I
noticed that all the text fields have a leading
apostrophe in them. I want to get rid of the
apostrophe. I've tried the VB code using .value I found
out on line, but it didn't work. Can someone tell me how
to get rid of the apostrophes.

Thanks,

John

PS
I'm using Excel 2002.

 

[Lady Layla]

Select area of text you need to do this to

Edit
Find
Enter ' in box
Replace with <leave blank>
Replace all



: Hi,
:
: I've created a microsoft excel worksheet from access. I
: noticed that all the text fields have a leading
: apostrophe in them. I want to get rid of the
: apostrophe. I've tried the VB code using .value I found
: out on line, but it didn't work. Can someone tell me how
: to get rid of the apostrophes.
:
: Thanks,
:
: John
:
: PS
: I'm using Excel 2002.

 

[DDM]

John, right-click an empty cell and Copy. Select all cells with apostrophes,
right-click and Paste Special > Add > OK.