Carriage return during an if statement

  • Thread starter Thread starter kpt
  • Start date Start date
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?
 
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"
 
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"
 
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...
 
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

Carriage return displays as a small box 8
Unicode text and carriage returns 4
Replacing carriage returns with a comma 4
Getting rid of carriage return in cell 4
Formatting in formulas not allowed before commas 5
copying/pasting accurately from a Word table (carriage returns) 1
Remove carriage returns in an Excel document? 3
how do i format carriage returns for each cell in excel? 1

Back
Top