Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you delete a cell then shift cell up? | Excel Discussion (Misc queries) | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
delete row contains specific word in an macro | Excel Discussion (Misc queries) | |||
Saving to a network share without delete permssions | Excel Discussion (Misc queries) | |||
Delete apostrophe | Excel Discussion (Misc queries) |