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".
|