Thread: Separate One Cell Into Many Rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SAR SAR is offline
external usenet poster
  
Posts: 1
Default Separate One Cell Into Many Rows

Cell A1 has 13,242 whole numbers listed, each separated by a semi-colon.
How can I separate all these numbers into 13,242 rows? I tried to do
columns to rows but Excel will not accomodate 13,242 columns. I put in
into Word, and still cannot figure it out. I need to do this process
every month with different numbers and a different amount of numbers in
Cell A1. Thanks for your help in advance.


--
SAR
------------------------------------------------------------------------
SAR's Profile: http://www.excelforum.com/member.php...o&userid=34172
View this thread: http://www.excelforum.com/showthread...hreadid=564815

Reply With QuoteReply With Quote