View Single Post
 
Old 08-26-2013, 11:16 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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".
Reply With Quote