Delete Leading Apostrophes in text fields

  • Thread starter Thread starter John Underwood
  • Start date Start date
J

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.
 
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.
 
John, right-click an empty cell and Copy. Select all cells with apostrophes,
right-click and Paste Special > Add > OK.
 
Back
Top