Carriage return during an if statement

K

kpt

I have several cells combined and during the IF stament I want to use
carriage return to align stuff with in the cell. Any ideas?
 
S

Sheeloo

Use CHAR(10)

=IF(A1=1,"First Line" & Char(10) & "Second Line","In one line only")

You may have to format the cell alignment as "Wrap Text"
 
S

Sheeloo

Use CHAR(10)

=IF(A1=1,"First Line" & Char(10) & "Second Line","In one line only")

You may have to format the cell alignment as "Wrap Text"
 
K

kpt

Thank you
works great

Sheeloo said:
Use CHAR(10)

=IF(A1=1,"First Line" & Char(10) & "Second Line","In one line only")

You may have to format the cell alignment as "Wrap Text"
Click to expand...
 
K

kpt

Thank you
works great

Sheeloo said:
Use CHAR(10)

=IF(A1=1,"First Line" & Char(10) & "Second Line","In one line only")

You may have to format the cell alignment as "Wrap Text"
Click to expand...
 

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
Carriage return displays as a small box 8
Getting rid of carriage return in cell 4
carriage return in text cell in excell 2
Replacing carriage returns with a comma 4
Parsing formatted data 6
Separating carriage return data into separate cells 2
vbYesNo, change carriage return 4

Top