how to get rid of the carriage return in text?

[poweryogi]

Hi everyone,
My first visit and already i have a question:
A collegue has given me a spreadsheet with text columns. A few columns have some characters that gives me problems when i want to use the cells in GIS software. I guess that the character is the carriage return, but i'm not sure. Can anybody tell me how to get rid of this char?
I was planning to copy an example into this message but the char is definetly the return. But i can't select the char in excel. Please help
gtrz Bart[/code]

 

[Hsibbs]

Have you tried using Replace, and replacing it with nothing (ie blank the replace input box) ) to get rid of it? Could you copy it to word (where carriage return is ^p) as this might be easier, then copy it back to excel????

 

[Richard Schollar]

Use the CLEAN function:

=CLEAN(A1)

for eg to remove non-printing characters from the text in cell A1.

Best regards

Richard

 

[klb]

Since the ALT ENTER keys are used for entering a carriage return in Excel, have you tried using the ALT ENTER keys as your search criteria? For replace either leave it blank or enter a space or whatever you want.

 

[poweryogi]

The clean function did the job!
Copying to word was no option: too much work.
I'm rather lazy then tired hence im glad with the clean function.
thx for your quick responses.
seeya