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 |
#2
|
|||
|
|||
Dino has responded to his initial post.
Dino Buljubasic wrote: 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 -- Dave Peterson |
Reply |
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 |