Merge multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey Everyone,

I need to merge multiple cells into one. Is there any way to do that
without having to copy and paste and text wrap in one cell? Basically, I
need A3 to A10 to merge into one cell without losing any of the text.

Thank You for your help!
 
Hi Ljoe,

=a3&a4&a5&a6&a7&a8&a9&a10

or if you need space between the texts of each cell use =a3&" "&a4&" " etc

hth
regards from Brazil
Marcelo

"LJoe" escreveu:
 
Not sure if there is a shorter way to do this but you could use.

=A3&A4&A5&A6&A7&A8&A9&A10
 
Yes, you're missing the fact that the data in A4:A10 would be lost.

Excel keeps only the data from the top left cell.


Gord Dibben MS Excel MVP
 
Aside from the spelling mistake, that formula won't work.

=CONCATENATE(A3,A4,A5,A6) is OK

Shorter is =A3&A4&A5&A6

And why a cell in column 11 or higher?

LJoe is merging cells from one column(A) only.


Gord Dibben MS Excel MVP
 
Back
Top