Merge multiple cells

[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!

 

[Guest]

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:

 

[Guest]

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

=A3&A4&A5&A6&A7&A8&A9&A10

 

[Sasa Stankovic]

CONCATENATE function

 

[ferg]

What about - highlight cells A3-A10 ,goto format, cells, merge cells
am I missin sumfin

 

[Gord Dibben]

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

 

[Guest]

choose a cell in column 11 or higher and use function "=CONCANTENATE(A3:A10)"

 

[Peo Sjoblom]

Did you try that?


--
Regards,

Peo Sjoblom

choose a cell in column 11 or higher and use function
"=CONCANTENATE(A3:A10)"

 

[Gord Dibben]

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