Thread: Combining text from several cells into 1 cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rick is offline
external usenet poster
  
Posts: 334
Default Combining text from several cells into 1 cell
I have text from a report that is spread over several cells. Each cell
contains 1 word. I want to bring all of these words into 1 cell, in Sheet1
A2. They come into Sheet1 in cells A1, B1, C1, D1, E1, F1, G1, H1. So A2
will contain all 8 words in 1 cell. Putting a space between words in A2 would
be best.
--
Rick
Reply With QuoteReply With Quote