Thread
:
how do I remove Carriage Returns from a column in a spreadsheet?
View Single Post
#
2
Nick Hodge
Posts: n/a
Doug
You could use a 'helper' column and the SUBSTITUTE function
This one replaces line feeds with nothing
=SUBSTITUTE(C2,CHAR(10),"")
Use CHAR(13) for carriage returns
You can then EditPaste special...Values once you have achieved both
operations
Put a space between the two double-quotes to enter a space instead of
nothing
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"Doug R" wrote in message
...
I have some data that I am manipulating in Excel to do an export to another
application. I need to be able to do a universal find and replace to get
rid
of instances of Carriage Returns and Line Feeds within the data. I have
tried the basic find and replace functions but I don't know how to make
them
find a carriage return character.
Any help would be greatly apreciated.
Reply With Quote