Insert line break and format text with CONCATENATE (or &)

Hi there!

I need to concatenate the content of two cells in one (using CONCATENATE or & works just fine...) but I would like the result to show in the resulting cell over two lines, and the first one being bold. Anyone?

Cell A1: "ABBR"
Cell A2: "FULL NAME"
Cell A3=A1 & " " & A2
Cell A3 displays "ABBR FULLNAME"

I need to display:

ABBR
FULLNAME

Anyone? Thanks!

Annie

Originally Posted by Pepe Le Mokko

Perhaps =A1&char(10)&a2 and click " wrap text in the format alignment tab ?

That in itself didn't do it, but I did find a way to insert at least the line break based on it! I just did =A1 & "" & A2, and inserted a line break between the quotation marks using alt+enter. With the wrap text, its doing just fine, no matter the width of the column. Thanks! (As for the bold format, I can always live without it...:P)

Originally Posted by Norie

Annie

That's not possible using formulas you would need code.

It looks like the line break part is, at least! :D (See previous reply)