Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-26-2013, 11:16 AM
BobBridges's Avatar
BobBridges BobBridges is offline Multiple data in one cell? Windows 7 64bit Multiple data in one cell? 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple data in one cell? 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
Multiple data in one cell? How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM
Multiple data in one cell? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft