Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 3rd 08, 04:42 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 6
Default can I copy a number of cells in a column to a single cell ina row

I have between 6 and 10 pieces of data which I wish to copy from the column
they are in, into a single cell (which has been merged to make it larger and
more visible to see) The data which is just a series of numbers or letters
(or a combination of both) do not need to be re-used from this merged cell
Can you help please?

Bev
--
Bev

  #2   Report Post  
Old July 3rd 08, 12:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default can I copy a number of cells in a column to a single cell ina row

You can use a formula like:

=a1&b1&c1&d1&....
or
=a1&" "&b1&" "&c1&" "&d1&...
or
=a1&char(10)&b1&char(10)&...
(to wraptext if the cell is formatted nicely)

If you have to do this for lots of cells, you may want to use this function from
JE McGimpsey:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)


Bev wrote:

I have between 6 and 10 pieces of data which I wish to copy from the column
they are in, into a single cell (which has been merged to make it larger and
more visible to see) The data which is just a series of numbers or letters
(or a combination of both) do not need to be re-used from this merged cell
Can you help please?

Bev
--
Bev


--

Dave Peterson
  #3   Report Post  
Old July 3rd 08, 12:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default can I copy a number of cells in a column to a single cell ina row

ps. The formula would be for a column:
=a1&a2&a3&....


Bev wrote:

I have between 6 and 10 pieces of data which I wish to copy from the column
they are in, into a single cell (which has been merged to make it larger and
more visible to see) The data which is just a series of numbers or letters
(or a combination of both) do not need to be re-used from this merged cell
Can you help please?

Bev
--
Bev


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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
I would like to copy UNIQUE data from a column in a SINGLE CELL Yogi Excel Discussion (Misc queries) 2 July 14th 07 07:20 AM
Copy column range of "single word" cells with spaces to a single c nastech Excel Discussion (Misc queries) 3 February 15th 06 05:04 PM
Copy column of cells to a single cell? nastech Excel Discussion (Misc queries) 7 February 15th 06 12:39 PM
How to I copy text from a range of cells to another single cell? WRT Excel Discussion (Misc queries) 2 December 18th 05 06:17 AM


All times are GMT +1. The time now is 10:22 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017