I want to be able to put text on several lines in one individual cell in
excel using the the carriage return without wrapping the text. I also want to
put spaces at the end of the sentence which stay there when you adjust the
width.

Alt+Enter at end of each line of text.

"Freddo" wrote:

I want to be able to put text on several lines in one individual cell in
excel using the the carriage return without wrapping the text. I also want to
put spaces at the end of the sentence which stay there when you adjust the
width.

For those spaces, you can try Char(160), the non-breaking space.

<Alt0160

Using the numbers on the NUM keypad, *not* the numbers under the function
keys.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Toppers" wrote in message
...
Alt+Enter at end of each line of text.

"Freddo" wrote:

I want to be able to put text on several lines in one individual cell in
excel using the the carriage return without wrapping the text. I also
want to
put spaces at the end of the sentence which stay there when you adjust
the
width.