MrExcel Publishing
Your One Stop for Excel Tips & Solutions

remove carriage returns


Posted by danielle on May 02, 2001 2:45 AM

Hello!

Does anyone know of a quick way to remove all carriage returns from a cell? I have imported some data from Access to Excel and one of the columns contains Notes. In every cell in this column there are carriage returns displayed by little boxes and I need to get rid of them!!

Thanks,
Danielle

Posted by Dave Hawley on May 02, 2001 3:14 AM


Hi Danielle

There is a bit of a trick to this. Go to Edit>Replace and in the "Find what" box hold down the Alt key and push 015 Leave the "Replace with" box blank and click "Replace All"

Dave

OzGrid Business Applications

Posted by Danielle on May 02, 2001 3:52 AM


Hi Dave,

I hope I'm not being really stupid here but do you mean press the three seperate keys : 0 then 1 then 5????

danielle

Posted by Dave Hawley on May 02, 2001 5:13 AM


Hi Danielle

>do you mean press the three seperate keys: 0 1 5


Yes, while hodling down Alt.

Dave
OzGrid Business Applications

Posted by Mark W. on May 02, 2001 6:09 AM

Danielle, you could use the CLEAN() function. Hello!

Posted by guess on June 07, 2001 9:48 PM

Hey DAve it didn't work???