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:

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!

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!

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!

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

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

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!

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!

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!