Merge multiple cells
 

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!

Merge multiple cells
 

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:

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!

Merge multiple cells
 

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

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

"LJoe" wrote:

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!

Merge multiple cells
 

CONCATENATE function
"LJoe" wrote in message
...
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!

Merge multiple cells
 

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


--
ferg
------------------------------------------------------------------------
ferg's Profile: http://www.excelforum.com/member.php...o&userid=36519
View this thread: http://www.excelforum.com/showthread...hreadid=563484

Merge multiple cells
 

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

On Fri, 21 Jul 2006 00:29:24 -0400, ferg
wrote:


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

Merge multiple cells
 

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

"LJoe" wrote:

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!

Merge multiple cells
 

Did you try that?


--
Regards,

Peo Sjoblom



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

"LJoe" wrote:

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!

Merge multiple cells
 

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

On Thu, 24 May 2007 15:44:00 -0700, lisann
wrote:

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

"LJoe" wrote:

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!