If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Copy multiple cells to one cell
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Copy multiple cells to one cell

#1
December 26th 07, 07:10 PM posted to microsoft.public.excel.misc
 Tigerxxx external usenet poster Posts: 78
Copy multiple cells to one cell

How can I copy data in multiple cells into one cell one after the other?
Example-
Cells A1=3, B1=4, C1=5......Y1=25, Z1=26
I want to copy the data in cells A1,B1 through Z1 into one single cell A2 as
3,4 ,5....26.

#2
December 26th 07, 07:28 PM posted to microsoft.public.excel.misc
 Marcelo external usenet poster Posts: 1,047
Copy multiple cells to one cell

Try to concatenate

=a1&", "b1"& etc

hth
--
regards from Brazil
Marcelo

"Tigerxxx" escreveu:

> How can I copy data in multiple cells into one cell one after the other?
> Example-
> Cells A1=3, B1=4, C1=5......Y1=25, Z1=26
> I want to copy the data in cells A1,B1 through Z1 into one single cell A2 as
> 3,4 ,5....26.
>

#3
December 26th 07, 07:57 PM posted to microsoft.public.excel.misc
 Tigerxxx external usenet poster Posts: 78
Copy multiple cells to one cell

As I understand concatenate can only work for five cells at a time. I was
looking for some other convenient way for higher number of cells.

Thank you

"Marcelo" wrote:

> Try to concatenate
>
> =a1&", "b1"& etc
>
> hth
> --
> regards from Brazil
> Marcelo
>
>
>
> "Tigerxxx" escreveu:
>
> > How can I copy data in multiple cells into one cell one after the other?
> > Example-
> > Cells A1=3, B1=4, C1=5......Y1=25, Z1=26
> > I want to copy the data in cells A1,B1 through Z1 into one single cell A2 as
> > 3,4 ,5....26.
> >

#4
December 26th 07, 08:18 PM posted to microsoft.public.excel.misc
 David Biddulph[_2_] external usenet poster Posts: 8,651
Copy multiple cells to one cell

Which 2 cells are you omitting between C1 and Y1?
--
David Biddulph

"Tigerxxx" > wrote in message
...
> How can I copy data in multiple cells into one cell one after the other?
> Example-
> Cells A1=3, B1=4, C1=5......Y1=25, Z1=26
> I want to copy the data in cells A1,B1 through Z1 into one single cell A2
> as
> 3,4 ,5....26.
>

#5
December 26th 07, 08:19 PM posted to microsoft.public.excel.misc
 David Biddulph[_2_] external usenet poster Posts: 8,651
Copy multiple cells to one cell

You understand wrongly. What made you think that?
--
David Biddulph

"Tigerxxx" > wrote in message
...
> Thanks for your input Marcelo.
>
> As I understand concatenate can only work for five cells at a time. I was
> looking for some other convenient way for higher number of cells.
>
> Thank you
>
> "Marcelo" wrote:
>
>> Try to concatenate
>>
>> =a1&", "b1"& etc
>>
>> hth
>> --
>> regards from Brazil
>> Marcelo
>>
>>
>>
>> "Tigerxxx" escreveu:
>>
>> > How can I copy data in multiple cells into one cell one after the
>> > other?
>> > Example-
>> > Cells A1=3, B1=4, C1=5......Y1=25, Z1=26
>> > I want to copy the data in cells A1,B1 through Z1 into one single cell
>> > A2 as
>> > 3,4 ,5....26.
>> >

#6
December 26th 07, 08:33 PM posted to microsoft.public.excel.misc
 Tigerxxx external usenet poster Posts: 78
Copy multiple cells to one cell

Hi David,

I am sorry...let me rephrase the example-
Example-
Cells A1=1, B1=2, C1=3......Y1=25, Z1=26
I want to copy the data in cells A1,B1 through Z1 into one single cell A2
i.e. I want to copy 26 cells into one single cell.

"David Biddulph" wrote:

> Which 2 cells are you omitting between C1 and Y1?
> --
> David Biddulph
>
> "Tigerxxx" > wrote in message
> ...
> > How can I copy data in multiple cells into one cell one after the other?
> > Example-
> > Cells A1=3, B1=4, C1=5......Y1=25, Z1=26
> > I want to copy the data in cells A1,B1 through Z1 into one single cell A2
> > as
> > 3,4 ,5....26.
> >

>
>
>

#7
December 26th 07, 09:58 PM posted to microsoft.public.excel.misc
 David Biddulph[_2_] external usenet poster Posts: 8,651
Copy multiple cells to one cell

The answer is to use concatenation, as previously explained.
=A1&", "&B1&", "&C1&", "&D1&", "&E1&", "&F1&", "&G1&", "&H1&", "&I1&",
"&J1&", "&K1&", "&L1&", "&M1&", "&N1&", "&O1&", "&P1&", "&Q1&", "&R1&",
"&S1&", "&T1&", "&U1&", "&V1&", "&W1&", "&X1&", "&Y1&", "&Z1
--
David Biddulph

"Tigerxxx" > wrote in message
...
> Hi David,
>
> I am sorry...let me rephrase the example-
> Example-
> Cells A1=1, B1=2, C1=3......Y1=25, Z1=26
> I want to copy the data in cells A1,B1 through Z1 into one single cell A2
> i.e. I want to copy 26 cells into one single cell.
>
>
> "David Biddulph" wrote:
>
>> Which 2 cells are you omitting between C1 and Y1?
>> --
>> David Biddulph
>>
>> "Tigerxxx" > wrote in message
>> ...
>> > How can I copy data in multiple cells into one cell one after the
>> > other?
>> > Example-
>> > Cells A1=3, B1=4, C1=5......Y1=25, Z1=26
>> > I want to copy the data in cells A1,B1 through Z1 into one single cell
>> > A2
>> > as
>> > 3,4 ,5....26.
>> >

>>
>>
>>

#8
December 27th 07, 02:41 AM posted to microsoft.public.excel.misc
 Max external usenet poster Posts: 9,221
Copy multiple cells to one cell

"Tigerxxx" wrote:
> Cells A1=1, B1=2, C1=3......Y1=25, Z1=26
> I want to copy the data in cells A1,B1 through Z1 into one single cell A2
> i.e. I want to copy 26 cells into one single cell.

Another option - try this sub by Gord Dibben

Sub ConCat_Cells()
'Gord Dibben .misc
Dim x As Range
Dim y As Range
Dim z As Range
Dim w As String
Dim sbuf As String
On Error GoTo endit
w = InputBox("Enter the Type of De-limiter Desired")
Set z = Application.InputBox("Select Destination Cell", _
"Destination Cell", , , , , , 8)
Application.SendKeys "+{F8}"
Set x = Application.InputBox _
("Select Cells...Contiguous or Non-Contiguous", _
"Cells Selection", , , , , , 8)
For Each y In x
If Len(y.Text) > 0 Then sbuf = sbuf & y.Text & w
Next
z = Left(sbuf, Len(sbuf) - 1)
Exit Sub
endit:
MsgBox "Nothing Selected. Please try again."
End Sub

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
#9
December 27th 07, 05:20 PM posted to microsoft.public.excel.misc
 Tigerxxx external usenet poster Posts: 78
Copy multiple cells to one cell

Thanks a lot for your help guys!

Hi Max,
The macro will ber very helpful!

Thanks!

"Max" wrote:

> "Tigerxxx" wrote:
> > Cells A1=1, B1=2, C1=3......Y1=25, Z1=26
> > I want to copy the data in cells A1,B1 through Z1 into one single cell A2
> > i.e. I want to copy 26 cells into one single cell.

>
> Another option - try this sub by Gord Dibben
>
> Sub ConCat_Cells()
> 'Gord Dibben .misc
> Dim x As Range
> Dim y As Range
> Dim z As Range
> Dim w As String
> Dim sbuf As String
> On Error GoTo endit
> w = InputBox("Enter the Type of De-limiter Desired")
> Set z = Application.InputBox("Select Destination Cell", _
> "Destination Cell", , , , , , 8)
> Application.SendKeys "+{F8}"
> Set x = Application.InputBox _
> ("Select Cells...Contiguous or Non-Contiguous", _
> "Cells Selection", , , , , , 8)
> For Each y In x
> If Len(y.Text) > 0 Then sbuf = sbuf & y.Text & w
> Next
> z = Left(sbuf, Len(sbuf) - 1)
> Exit Sub
> endit:
> MsgBox "Nothing Selected. Please try again."
> End Sub
>
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---

#10
December 28th 07, 01:55 AM posted to microsoft.public.excel.misc
 Max external usenet poster Posts: 9,221
Copy multiple cells to one cell

Welcome, think Gord would be pleased to hear that as well !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tigerxxx" > wrote in message
...
> Thanks a lot for your help guys!
>
> Hi Max,
> The macro will be very helpful!
>
> Thanks!

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post How to Copy single Cell into Multiple cells Nitesh Mathur Excel Worksheet Functions 3 December 12th 07 09:35 AM macro copy/paste data from multiple cells to multiple cells Diana Excel Discussion (Misc queries) 0 July 10th 06 09:24 PM How to copy multiple cells between worksheets Dominic Excel Discussion (Misc queries) 3 February 1st 06 02:23 PM List box, copy multiple Cells [email protected] Excel Worksheet Functions 1 September 8th 05 11:29 PM How to copy and paste same formula in multiple cells? Amanda Excel Worksheet Functions 1 June 30th 05 04:16 PM

All times are GMT +1. The time now is 10:20 PM.