| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to replace a tilde with the corresponding headword
Thank you all! That's what I need.
However your macro distorts all the formatting in colum B. I tested both macros on this file: http://rapidshare.com/files/9898670/Before.xls.html and ended up with this: http://rapidshare.com/files/9899030/After.xls.html Can the macro be amended to preserve the original formatting? Thanks again! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parsing text containing a tilde "~"? | Excel Discussion (Misc queries) | |||
| Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
| How to perform Search and Replace on "Tilde", CHAR(126), ~ | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| how do I type a tilde over the letter "n" in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
