| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find and replace all "*" symbols
You need to let Excel know that the * is not to be used as a wildcard..a
tilde (~) is used for that. Try this: From the Excel main menu: <edit<replace Find what: ~* Replace with: (enter your replacement text here...or leave it blank) Click the [OK] button All asterisks will be replaced. Does that help? *********** Regards, Ron XL2002, WinXP "Roger" wrote: When I tried this the logical way it replaced everything.. thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to cancel a find & replace command "midstream"? | Excel Worksheet Functions | |||
| Macro: Find and replace | Excel Discussion (Misc queries) | |||
| Find and Replace Technique to modify stock symbols. | Excel Discussion (Misc queries) | |||
| How Can I find and replace symbols in excel data ( white square) | Excel Discussion (Misc queries) | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Threaded Mode
