HELP - How to replace CRLF with a character withing an excel column

D

Dino Buljubasic

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
 
D

Dave Peterson

Dino has responded to his initial post.

Dino said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i replace a known delimiter with a carage return? 2
How to remove or replace a carriage return character in a cell? 2
Using replace box to change a character into a CR (Alt-Enter char) 2
Substituting CRLF with "+" - Transforming a cell containing numbersin a sum of its numbers 2
How do I search and replace with a line break? 12
more character 160 leading/trailing find/replace problems 6
How to Find/Replace * (asterisk) in cell content 4
Square-box character in data import 10

Top