Is there a way to remove carriage return in Excel exported frm Out

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to remove carriage returns in Excel. The information I needed
was exported from Outlook. Please Help!
 
Select the data, press Ctrl+H, hold down the Alt key, and
type 0010 from your numeric keypad. Leave "Replace With"
empty. Replace all.

HTH
Jason
Atlanta, GA
 
Rachel

If you have carriage returns in a cell you should be able to see them if you
turn off "text wrapping" on that cell.

You will see a square box at each return.

Try Edit>Replace

what: ALT + 0010(on numpad)
with: space(or nothing)

OR ALT + 0013

If this fails, try the CLEAN Function.

Post back if more is needed. There are a few other avenues of approach.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Carriage return displays as a small box 8
Unicode text and carriage returns 4
Getting rid of carriage return in cell 4
Remove carriage returns in an Excel document? 3
Formatting in formulas not allowed before commas 5
How to remove newlines from worksheet 1
copying/pasting accurately from a Word table (carriage returns) 1
Show or Hide control characters in a cell (using Excel 2007)... 0

Back
Top