Thread: How do I copy the contents of a range of text cells and paste into one cell?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
CaptainQuattro CaptainQuattro 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?

Use text concatenation formulas as follows:


Formula in Cell Sheet1!A1 of Book2:

=+[Book1]Sheet1!$A$2&[Book1]Sheet1!$A$3

Afterwards, convert everything to static values.


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

Reply With QuoteReply With Quote