Delete apostrophe

[Susana Conklin via OfficeKB.com]

Hi Again,

I have a database with over 14400 lines of info that I need to delete the apostrophe before the value, how do I do this?

 

[Dave R.]

It always helps to include some examples of what your data looks like ... if
it looks like this ",145,000,00S" then the answer is different than if it
looks like this ",145000"

For the first, you could use =RIGHT(A1,LEN(A1)-1) or =MID(A1,2,99999)

For the second you could just select the range, press CTRL-H and search for
"," (without the quotes) and leave 'replace with' blank.

Hi Again,

I have a database with over 14400 lines of info that I need to delete the

apostrophe before the value, how do I do this?

 

[Don Guillett]

one way
put 1 in a vacant cell>copy that cell>edit>pastespecial>multiply
done


--
Don Guillett
SalesAid Software
(e-mail address removed)

Hi Again,

I have a database with over 14400 lines of info that I need to delete the

apostrophe before the value, how do I do this?

 

[Steve Walton]

It always helps to include some examples of what your data looks like ... if
it looks like this ",145,000,00S" then the answer is different than if it
looks like this ",145000"

For the first, you could use =RIGHT(A1,LEN(A1)-1) or =MID(A1,2,99999)

For the second you could just select the range, press CTRL-H and search for
"," (without the quotes) and leave 'replace with' blank.




apostrophe before the value, how do I do this?

it was apostrophe not comma, and so is a probably a text based entry
issue
but a decent example always helps

Steve