In B12, =A4 and drag it down to B17, no, it makes no difference whether its
text or numbers,
Regards,
Alan.
"Concarp" wrote in message
...
Help! I need to copy data in cell A4-A9 INTO CELLS B12-17 The info is
names
of states.
BUT Would the formula be diffrent if it were numers?
Also how / when & which do I use - click & drag or the autofill handle
thing?
I can't just do copy/paste or I'll lose points on test!! I need the
formula.
THANKX
ConCarp