Find/Replace carriage return & line feed characters in Excel.

G

Guest

I have symbols in my Excel 2002 data that represent carriage returns and line
feeds "char(10) & char(13)". I want to find/replace these symbols.
 
G

Guest

Try edit>repalce, find what hold down alt and type 010, release alt key,
do the same but use 013
Regards,

Peo Sjoblom
 

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

Parse Before Line Break 3
how to copy excel carriage return to notepad w/out the quotations 4
Split data in field on character return 0
Address block carriage returns not correct 3
Replacing ascii characters 2
Remove Carriage Return symbols from data 2
Verifying line feed endings 3
Restoring line breaks in memo field 1

Top