How do I eliminate carriage returns in a cell
 

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

How do I eliminate carriage returns in a cell
 

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?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Squirrelwatcher" wrote in
message ...
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

How do I eliminate carriage returns in a cell
 

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

"Bernard Liengme" wrote:

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?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Squirrelwatcher" wrote in
message ...
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