![]() |
|
#2
|
||||
|
||||
|
Other people may have different opinions about this, but my own answer is that it's possible but usually inadvisable.
The "possible" part is that you can save three values as a comma-delimited string, eg "14000,online,REGULAR". Other cells that need to handle one of those values could use the FIND function to figure out that there's a comma in position 6, and then convert the first five characters into a number and calculate with it. You could write your own worksheet functions, too, to pick out the 1st, 2nd or 3rd value in a cell. But the "inadvisable" part is that it's a lot more complicated to do that. I've been tempted to it myself, several times, but each time I end up deciding that the saved space isn't worth the extra effort. Maybe someday the good folks at Microsoft will invent a feature in Excel that lets you invent additional properties in a single cell. But I'm betting they've already thought about it and decided "nah; that's what multiple cells are for". |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Formulas in one Cell one Formula Away From Completion
|
microsoftnovice | Excel | 2 | 12-05-2012 12:54 PM |
| Move data from 1 cell to another cell | Catalin.B | Excel | 1 | 06-25-2011 12:51 PM |
How to count multiple values in a single cell, except zero?
|
iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
Sum & difference between multiple values in a single cell
|
iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |
| Splitting Excel cell into multiple | ruben23 | Excel | 1 | 07-23-2009 03:49 AM |