I have a spreadsheet, with a column of cells each holding 4 items of data. These are comma-separated, and I want to give each item their individual column. Is there a function that is the 'opposite' of Concatenation? Or could I possibly do some sort of .csv conversion?
If this is not feasible, I am looking for a function that will count occurrences, but ONLY if the item is in upper case.
The column is set out similar to this-
CAT, DOG, fish, cow
HORSE, cow, DOG, CAT
DOG, whale, HORSE, cow
I want to count all the cats, dogs, etc, but not fish or cows....
Any pointers would be very much appreciated!
The key to everything is patience. You get the chicken by hatching the egg, not smashing it.
Ex-Editor, Hobbies and Sports, and Forum Moderator