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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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 character with carriage return 2
Removing Mulitple Carriage Returns Within a Concantenate Formula 2
Verifying line feed endings 3
Splitting text divided by carriage returns 2

Back
Top