how to transform multiple column to one CELL.?

Question

A1:ABC company
A2: No 3, flower road
A3: Percient 36B
A4: 452919
A5: Brisbane
A6: Australia

CONVERT TO IN ONE CELL WITH DIFFERENT ROW(DIFFERENT LEVEL),

ABC company
No 3, flower road
Percient 36B
452919 Brisbane
Australia

Answer 1

=A2 & CHAR(10) & B2 & CHAR(10) & C2 & CHAR(10) & D2 & CHAR(10) & E2 & CHAR(10) & F2

Using CHAR(10) will make the text go to the next line. CHAR(13) is similar, but CHAR(10) should work without you having to play with word wrap settings.

& is the concatenate operator. I combines (concatenates) text together.

Answer 2

I think you want the formal



=A1 & CHAR(13) & A2 & CHAR(13) & A3 & CHAR(13) & A4 & " " & A5 & CHAR(13) & A6



You may have to change the formatting of the cell with the formula to Word Wrap.

Answer 3

thank youuuu Micheal E and Dan ! i have to learn char formula..(never heard of char before)...TQVM