How do I eliminate carriage returns in a cell

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

Guest

I have a data base of names and addresses with the address in one field with
the seperator being a carriage return. I would like to chane that so I can
use the text to columns function in Excel
 
In A1, I entered "hot", pressed ALT+ENTER, "dog"
A1 displayed the text with one word under the other
In B1, I use =SUBSTITUTE(A1,CHAR(10)," ") and B1 displayed the two words
with a space between them.
I used Copy followed by Paste Special->Values to get this as text
Now I can use Text to Columns
Any help?
 
Thanks Bernard for your help. Sorry this question appeared in Charts and the
delay in saying thanks. It took me a while to find the reply button
 
Back
Top