is it only appropriate to insert *different* data into *individual* cells...

S

showsomeidnow

.... like this i mean

column A column B
apple £1.20
banana £1.30
pear £2.25

or is this 'acceptable' also?

column A
apple £1.20
banana £1.30
etc
 
P

Peo Sjoblom

If it is just for display it won't do any harm but I would recommend against
it due to that if you want to do any sort of calculation a good standard
would be to separate numbers from text or else the formulas involved will be
much more complicated and probably a lot slower on a grander scale of data.
So I would avoid it.


--
Regards,

Peo Sjoblom

.... like this i mean

column A column B
apple £1.20
banana £1.30
pear £2.25

or is this 'acceptable' also?

column A
apple £1.20
banana £1.30
etc
 
D

Dave Peterson

You can do whatever is appropriate.

But if you separate fields into different columns, your life will be much, much
simpler if you ever want to do anything with that data (besides printing).

For instance, if you wanted to add the values in column B, you could use:
=sum(b2:B99)

It would become a very ugly formula if you kept everything in column A.
 
B

Bernard Liengme

The second method is NOT recommended. It limits what can be done with the
data.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

.... like this i mean

column A column B
apple £1.20
banana £1.30
pear £2.25

or is this 'acceptable' also?

column A
apple £1.20
banana £1.30
etc
 
E

Elkar

It really depends on what you plan to do with the data after you've got it
entered. If you're going to perform any calculations, sorting or lookups on
individual elements of the data, then you'll have a much easier time if each
element is in its own cell. Otherwise, its just a matter of whichever way
you prefer.

HTH,
Elkar
 
S

showsomeidnow

thanks all for the replies as always. i really DO appreciate all the
help you guys (and ladies) give :)
 
Top