Thread: How do I copy the contents of a range of text cells and paste into one cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
davfin davfin is offline
external usenet poster
  
Posts: 1
Default How do I copy the contents of a range of text cells and paste into one cell?

Hi,
Excel 2003 question:

I have a sheet that contains text in consecutive cells (in a column), I
need to copy all the consecutive cells' texts into one cell in a
separate spreadsheet.
Is there any quick way to do this? Just selecting the individual texts
and copy/pasting is time consuming and a pain. I have multiple
occurrences of this and need to find a quick way.

All help and suggestions very much appreciated.
Thanks,
Dave.


--
davfin
------------------------------------------------------------------------
davfin's Profile: http://www.excelforum.com/member.php...o&userid=36012
View this thread: http://www.excelforum.com/showthread...hreadid=557961

Reply With QuoteReply With Quote