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,
--
Cong Nguyen

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
--
Kevin Backmann


"Cong Nguyen" wrote:

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,
--
Cong Nguyen

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...
-----------------------------------------------------------------------
"Cong Nguyen" wrote in message
...
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,
--
Cong Nguyen

Cong, check your other post.
"Cong Nguyen" wrote in message
...
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,
--
Cong Nguyen

On Thu, 30 Aug 2007 06:24:03 -0700, Cong Nguyen
wrote:

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,

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

Dear Ron Rosenfeld ,
This works great.
Thank you.

Regards,
Cong


--
Cong Nguyen



"Cong Nguyen" wrote:

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,
--
Cong Nguyen

On Thu, 30 Aug 2007 07:18:06 -0700, Cong Nguyen
wrote:

Dear Ron Rosenfeld ,
This works great.
Thank you.

Regards,
Cong


You're welcome. Thanks for the feedback
--ron