How to I carriage return in "text" cell?

B

Brett

How can I do a carriage return in a text cell? It alway puts me in
another cell when I press <enter>.

Also, can I use bullets in a text cell?

Thanks,
Brett
 
S

SidBord

I'm not going to be much help, but what you need to do is
write your text string in three parts:
" first part of text " & CHAR(??) & " last part of string "
I can't remember the character code for carriage return
(line feed??), but when you find it, replace the "??" in my
example with that code. It might be 60.
 
D

Dave Peterson

10, as in:

="asdf"&char(10)&"qwer"


I'm not going to be much help, but what you need to do is
write your text string in three parts:
" first part of text " & CHAR(??) & " last part of string "
I can't remember the character code for carriage return
(line feed??), but when you find it, replace the "??" in my
example with that code. It might be 60.
Click to expand...
 
Top