Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it only appropriate to insert *different* data into *individual* cells...
.... 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it only appropriate to insert *different* data into *individual* cells...
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 "showsomeidnow" wrote in message oups.com... .... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it only appropriate to insert *different* data into *individual*cells...
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. showsomeidnow wrote: ... 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it only appropriate to insert *different* data into *individual* cells...
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 "showsomeidnow" wrote in message oups.com... .... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it only appropriate to insert *different* data into *individual
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 "showsomeidnow" wrote: .... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it only appropriate to insert *different* data into *individual
thanks all for the replies as always. i really DO appreciate all the
help you guys (and ladies) give :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Comma Seperated data into individual Cells | Excel Discussion (Misc queries) | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
INSERT A ROW AFTER EVERY 5 CELLS IN A SHEET THAT HAS DATA OF 120 | Excel Discussion (Misc queries) | |||
insert zeros in front of cells already filled with data. | Excel Discussion (Misc queries) | |||
How do I merge individual data now in multiple cells, in to one b. | Excel Worksheet Functions |