Chris Wrote:
Any ideas how to get this format of numbers into 1 column?

0 25 50 75 100 I would like this:
0
125 150 175 200 225
25
300 325 350 375 400
50

75.....etc
Hi Chris,

Play around with this,
0 in cell A1, 25 in A3, then select A1:A4 and copy this down column A
to as far as your numbering goes.
Then 125 in cell B2, 150 in cell C2, copy over to F2
Then in G2 put this formula
=CONCATENATE(B2," ",C2," ",D2," ",E2," ",F2)
carry on with this down to the fourth row, then you can drag/copy down
When you have done this you can copy paste, value only and delete
column B:F

Let me know how you get on

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=573238