Thread: Multiple Rows Into One
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
joel joel is offline
external usenet poster
  
Posts: 9,101
Default Multiple Rows Into One
If you copy the cells and paste them into Notepad. Then copy them back again
from Notepad and paste them into fx box in excel.

"PR" wrote:

Is there a quick way of turning text that is on multiple rows into one row,
one problem that have with this, is that I have text say in 4-7 that I what
all in row 4, then the next maybe row 8 & 9 into row 8, then the next maybe
row 12-14 into row 12 and so on. They is no pattern to this...


Regards - Paul



Reply With QuoteReply With Quote