view carriage returns

F

Frank Stone

I don't believe excel has carriage returns in the context
as word has carriage returns.
why do you think excel has carriage returns?
 
S

see Brad V. post.

Perhaps you're referring to Alt + Enter(s) to break for
new lines within a
cell ?
Try in say, B1: =SUBSTITUTE(A1,CHAR(10)," ")
--
Rgds
Max
-----Original Message-----
i have an excel file that has several lines (within the same cell) that are
on multiple lines. I want them all on the same line. I know there is a
carriage return (or something there to make the line stop and continue on
another line), because when I expand the column, the lines stay on the
multiple lines, instead of spreading out on the one line.

I've also tried opening it in Word. I can see the carriage returns. I wanted
to work within Excel, because it is easier for what I am doing. I don't want
to replace all carriage returns with a space, just those in a specific
column, and it is easier to do that in Excel rather than Word, where the data
is all over the place. The problem is that I can't see the carriage returns
in Excel.

I am using this file to import into another application where I want all
these lines on one line. I have to correct this here, either in excel or in
another application before I can continue.

Thanks.
Click to expand...
 
M

Max

see Brad V. post. said:
Perhaps you're referring to Alt + Enter(s) to break for
new lines within a
cell ?
Try in say, B1: =SUBSTITUTE(A1,CHAR(10)," ")
Click to expand...

Thanks to the kind soul "see Brad V. post." for the "transfer"
of my suggestion to Brad from the other branch of the thread..

Think Brad has since got what he wanted in Gord's response
 
Top