Use a Carriage Returns when typing data into a text cell

  • Thread starter Thread starter Far Farley
  • Start date Start date
F

Far Farley

What is the code for entering a carriage return in a text cell.? I
tried & char(10) &, but it didn't work.

What I want is to type

Far[the_char_return_code]Farley

resultng in

Far
Farley



** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **
 
Hi
char(109 is correct. You have to format the cell with word wrap in
addition ('Format - Cells - Alignment')
 
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

Use a Carriage Return when typing data into a text cell 2
How do I parse for fields separated by a carriage control within a cell? 1
help with division 1
Carriage return in a text cell 3
changein text to all caps 6
numeric amount in word figers 2
VBA Loops 1
sending attachement 1

Back
Top