How to I carriage return in "text" cell?

  • Thread starter Thread starter Brett
  • Start date Start date
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
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unicode text and carriage returns 4
Getting rid of carriage return in cell 4
carriage return in text cell in excell 2
Excel - carriage returns and formating of text within a cell 2
Carriage return displays as a small box 8
Separating carriage return data into separate cells 2
How do i hide carriage returns? 1
Select text before carriage return 2

Back
Top