Formula to copy cell data
 

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

Formula to copy cell data
 

Put in B12: =IF(A4="","",A4)
Copy B12 down to B17
(Drag the fill handle at the bottom right corner of B12)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Concarp" wrote:
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

Formula to copy cell data
 

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

Formula to copy cell data
 

YOU GUYS ROCK!!
THANK YOU SOOO MUCH!
CC

"Alan" wrote:

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

Formula to copy cell data
 

YOU GUYS RIOCK THANKX SO MUCH!!

"Max" wrote:

Put in B12: =IF(A4="","",A4)
Copy B12 down to B17
(Drag the fill handle at the bottom right corner of B12)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Concarp" wrote:
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

Formula to copy cell data
 

You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Concarp" wrote in message
...
YOU GUYS ROCK THANKS SO MUCH!!