Carriage Return

[Guest]

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.

 

[Guest]

Alt+Enter at end of each line of text.

 

[Ragdyer]

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

<Alt>0160

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