How do I eliminate carriage returns in a cell

  • Thread starter Squirrelwatcher
  • Start date
S

Squirrelwatcher

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
 
B

Bernard Liengme

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?
 
S

Squirrelwatcher

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replacing a phrase with carriage returns 1
Merging from an Excel file with graphics 1
Split data around a carriage return 10
Hard carriage return at the end of cell 2
data spans multiple rows within each cell is collapsed when FILTER is used 0
Carriage return in text box. 2
Unicode text and carriage returns 4
Excel does not accept text format! 0

Top