| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HELP - How to replace CRLF with a character withing an excel column
Hi,
One of the columns in my excel has its content broken into lines. I guess each line within that column ends with a carrieage return and line feed. how can I replace these with say a "-" character? I was trying to use Find and Replace but don't know how to enter the CRLf character and if I use Alt 13 and / or Alt 10 (for cariage return and line feed) it wont fine these. Any help will be appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) | |||
| How to remove or replace a carriage return character in a cell? | Excel Discussion (Misc queries) | |||
|
Search and replace character with |
Excel Discussion (Misc queries) | |||
| How do I replace a character with another? | Excel Discussion (Misc queries) | |||
| Search and replace | Excel Worksheet Functions | |||
Threaded Mode
