Hi Jared

Try
="a"&ROW(2:2)&"b"
and copy down.
If you want to "fix" the data, copy the resulting column, and
PasteSpecialValues

--
Regards

Roger Govier


"Jared" wrote in message
...
if my series is a2b, a3b, a4b, a5b how do i use excel to fill the rest
a6b
a7b and not repeat a2b a3b

thanks
jared