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"
 
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"
 

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

Top