CHAR function

[lwilt]

I am trying to combine 3 cells per line and use the char function to have a line break between each of those 3 cells in their new combined cell.

I tried:
=(CONCATENATE("Notes1 ", CHAR(10),N2,CHAR(10),"Notes2 ",O2,CHAR(10),"Notes3 ",P2))

For an example on how to make it work please use cells A1,A2,A3 and combined them in A4.

I'm on excel 2010

 

[Luke M]

=A1&CHAR(10)&A2&CHAR(10)&A3

Make sure that cell A4 is set to enable word wrap, or the line break will just appear as a square symbol.

 

[lwilt]

its not making a line break, everything stays on the same line

 

[lwilt]

just changed it to word wrap with my original formula and it sort of worked.

After notes one it creates the line break and inserts the information from the first cell but then the next two notes sections it doesn't create a line break. The data is just next to notes2 and notes3.

can someone look at my formula to make sure I didn't mess anything up

 

[Xiq]

Hi Lwilt,

It seems to me both formulas work (if you "Wrap Text" only), though your original formula is missing a few char(10)'s

="Notes1 "&CHAR(10)&A1&CHAR(10)&"Notes2 "&CHAR(10)&A2&CHAR(10)&"Notes3"&CHAR(10)&A3

=CONCATENATE("Notes1 ", CHAR(10),A1,CHAR(10),"Notes2 ", CHAR(10),A2,CHAR(10),"Notes3 ", CHAR(10),A3)

 

[Abhijeet R. Joshi]

The one mentioned by Luke seems to work to me as well.

=A1&CHAR(10)&A2&CHAR(10)&A3

Make sure that cell A4 is set to enable word wrap, or the line break will just appear as a square symbol.​

You need to enable wrap text at A4 and then apply the formula...