Formula to copy cell data

[Guest]

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

 

[Guest]

Put in B12: =IF(A4="","",A4)
Copy B12 down to B17
(Drag the fill handle at the bottom right corner of B12)

 

[Alan]

In B12, =A4 and drag it down to B17, no, it makes no difference whether its
text or numbers,
Regards,
Alan.

 

[Guest]

YOU GUYS ROCK!!
THANK YOU SOOO MUCH!
CC

In B12, =A4 and drag it down to B17, no, it makes no difference whether its
text or numbers,
Regards,
Alan.

 

[Guest]

YOU GUYS RIOCK THANKX SO MUCH!!

Put in B12: =IF(A4="","",A4)
Copy B12 down to B17
(Drag the fill handle at the bottom right corner of B12)

 

[Max]

You're welcome !