Text to column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

Is there a quick way to populate a range of number from one cell, e.g.,
230-235 in cell A1 to their individual cell:
230 (in A1) 231 (in B1) 232 (in C1) 233 (in D1) 234 (in E1) 235
(in F1)?

My worksheet has too many of these 'sequence numbers' and can't use the
"FILL" function.

Thank you for the great help.
Regards,
 
Enter the starting number in A1 then place the following formula in B1:
=A1+1

Copy the formula across row one to the last column
 
Put 230 in cell A1. Grab the fill handle (lower right corner of cell) and drag to right
holding Ctrl key. Don't let go of the Ctrl key until you've released the mouse.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Hi All,

Is there a quick way to populate a range of number from one cell, e.g.,
230-235 in cell A1 to their individual cell:
230 (in A1) 231 (in B1) 232 (in C1) 233 (in D1) 234 (in E1) 235
(in F1)?

My worksheet has too many of these 'sequence numbers' and can't use the
"FILL" function.

Thank you for the great help.
Regards,
Click to expand...

B1:
=IF((LEFT($A1,FIND("-",$A1)-1)+COLUMNS($A:A)-1)>
--MID($A1,FIND("-",$A1)+1,255),"",LEFT($A1,FIND(
"-",$A1)-1)+COLUMNS($A:A)-1)

Fill right far enough to account for the greatest possible range.

You can then either
Hide column A
or
Select the area with the above formulas
Edit/Copy
Edit/Paste Special/Values
Then Delete column A
--ron
 
Back
Top