Archive of Mr Excel Message Board


Back to Edit in Excel archive index
Back to archive home

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


Re: remove carriage returns

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


Re: remove carriage returns

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


Re: remove carriage returns

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


Re: remove carriage returns

Posted by Mark W. on May 02, 2001 6:09 AM
Danielle, you could use the CLEAN() function. Hello!


Re: remove carriage returns

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

Hey DAve it didn't work???


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.