A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Copy multiple cells to one cell



 
 
Thread Tools Display Modes
  #1  
Old December 26th 07, 07:10 PM posted to microsoft.public.excel.misc
Tigerxxx
external usenet poster
 
Posts: 78
Default 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.

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

Try to concatenate

=a1&", "b1"& etc

hth
--
regards from Brazil
Thanks in advance for your feedback.
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.
>
> Please advise.

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

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
> Thanks in advance for your feedback.
> 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.
> >
> > Please advise.

  #4  
Old December 26th 07, 08:18 PM posted to microsoft.public.excel.misc
David Biddulph[_2_]
external usenet poster
 
Posts: 8,651
Default 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.
>
> Please advise.



  #5  
Old December 26th 07, 08:19 PM posted to microsoft.public.excel.misc
David Biddulph[_2_]
external usenet poster
 
Posts: 8,651
Default 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
>> Thanks in advance for your feedback.
>> 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.
>> >
>> > Please advise.



  #6  
Old December 26th 07, 08:33 PM posted to microsoft.public.excel.misc
Tigerxxx
external usenet poster
 
Posts: 78
Default 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.

Please advise. Thank you.

"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.
> >
> > Please advise.

>
>
>

  #7  
Old December 26th 07, 09:58 PM posted to microsoft.public.excel.misc
David Biddulph[_2_]
external usenet poster
 
Posts: 8,651
Default 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.
>
> Please advise. Thank you.
>
> "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.
>> >
>> > Please advise.

>>
>>
>>



  #8  
Old December 27th 07, 02:41 AM posted to microsoft.public.excel.misc
Max
external usenet poster
 
Posts: 9,221
Default 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  
Old December 27th 07, 05:20 PM posted to microsoft.public.excel.misc
Tigerxxx
external usenet poster
 
Posts: 78
Default 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  
Old December 28th 07, 01:55 AM posted to microsoft.public.excel.misc
Max
external usenet poster
 
Posts: 9,221
Default 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

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

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 05:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.