Use a Carriage Return when typing data into a text cell

F

Far Farley

What is the code for entering a carriage return in a text cell.? (not
using a char map lookup)

I tried "& char(10) &" and various combinations using alt, with no luck.

What I want is to type

Far[the_char_return_code]Farley[ENTER]

resultng in

Far
Farley

in the same cell. I know it exists, because a long time ago I found a
spreadsheet that had it in the cell, and I copied the cell. I have been
using that, but going to that worksheet and copying that character is a
bit of a pain in the butt. There HAS to be a better way of doing it
than that.

TIA

Far Farley
The Professional Network




** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **
 
C

Chip Pearson

In a formula, use

="First Line" & CHAR(10) & "Second Line"

When typing text in a cell, use ALT+Enter.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

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 Returns when typing data into a text cell 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Excel does not accept text format! 0
Enter carriage return in Excel 2010 text string 2
Hard carriage return at the end of cell 2
Insert Index into a Table 1
Populate cell with multiple non-blank text values 4
Visio shape text disappears upon copy paste 1

Top