If you just want Numbers in B1 - B105 (i.e. 1,2,3,4,5,6,7,etc.) then in
cell B1 enter 1 then in B2 enter =B1+1 and then copy and paste as far
as you need to go - then if you want you can get "rid" of the formula -
do a copy and paste special - values.
If you want something like B1, B2, B3, B4, etc. then do the same as
above and then in another column - enter B or what ever text you want
for each cell and then use the CONCATENATE function.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=536052