| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Hard Return; Special Character
I'm looking for a simple macro that deletes all hard returns in all cells in
a large worksheet. These hard returns originally came from Outlook's BCM. In Excel, the characters look like a small square, and when copied and pasted into Word, they look like this "^" or even this "^l". Does anyone have any idea how to delete all such characters on a sheet, or all such characters in a specified range (A1:CA6000). Regards, Ryan-- -- RyGuy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return True if cell contains special character | Excel Discussion (Misc queries) | |||
| Delete special character | Excel Discussion (Misc queries) | |||
| Seeking the character code for entering a Hard Return in a cell? | Excel Discussion (Misc queries) | |||
| Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
| Function to return Character Position of Xth character within a string | Excel Programming | |||
Threaded Mode
