Carriage return during an if statement

[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?

 

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

 

[kpt]

Thank you
works great

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"