Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing all asterisks in Excel 2003 spreadsheet
I am working on a spreadsheet that I have pulled data from another source.
Some of the cells contain double asterisks ** and other cells contain the data that I want to work with. I wanted to eliminate the ** so I tried to Replace All the ** with a space, but when I do this all my data disappears. Is there a way to eliminate the ** only and not the other data? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing all asterisks in Excel 2003 spreadsheet
Try
Find what: ~** Replace with: (nothing) [instead of Find what: ** ] aha? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "JoeP" wrote: I am working on a spreadsheet that I have pulled data from another source. Some of the cells contain double asterisks ** and other cells contain the data that I want to work with. I wanted to eliminate the ** so I tried to Replace All the ** with a space, but when I do this all my data disappears. Is there a way to eliminate the ** only and not the other data? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing all asterisks in Excel 2003 spreadsheet
The asterisk is a wildcard character staning for all characters.
If you want to replace an asterisk, yo must precede it with the tilde symbol, ~ ie: Find what ~* Replace with leave blank Click Replace All Hope this helps. Pete On Aug 20, 2:39*pm, JoeP wrote: I am working on a spreadsheet that I have pulled data from another source.. * Some of the cells contain double asterisks ** and other cells contain the data that I want to work with. I wanted to eliminate the ** so I tried to Replace All the ** with a space, but when I do this all my data disappears. Is there a way to eliminate the ** only and not the other data? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing all asterisks in Excel 2003 spreadsheet
Just to add to the other replies...
If you want to replace an asterisk character, use ~* in the from string. If you want to replace a question mark, use ~? in the from string. If you want to replace a tilde (~), use ~~ in the from string. JoeP wrote: I am working on a spreadsheet that I have pulled data from another source. Some of the cells contain double asterisks ** and other cells contain the data that I want to work with. I wanted to eliminate the ** so I tried to Replace All the ** with a space, but when I do this all my data disappears. Is there a way to eliminate the ** only and not the other data? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
Replacing Values in a Spreadsheet | Excel Discussion (Misc queries) | |||
Replacing Values in a Spreadsheet | Excel Discussion (Misc queries) | |||
XL 2003: Replacing X-Axis Labels with Custom Ones... | Charts and Charting in Excel | |||
Asterisks in Excel | Excel Discussion (Misc queries) |