Delete apostrophe
 

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?

--
Message posted via http://www.officekb.com

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.



"Susana Conklin via OfficeKB.com" wrote in message
...
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?

--
Message posted via http://www.officekb.com

one way
put 1 in a vacant cellcopy that celleditpastespecialmultiply
done


--
Don Guillett
SalesAid Software

"Susana Conklin via OfficeKB.com" wrote in message
...
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?

--
Message posted via http://www.officekb.com

On Fri, 3 Dec 2004 08:19:18 -0800, "Dave R."
wrote:

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.



"Susana Conklin via OfficeKB.com" wrote in message
m...
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?

--
Message posted via http://www.officekb.com


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

Steve