 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2006Displaying Multiple Cell Information in Single Cell
Hi all, I'm trying to present (text) data from multiple cells in another workbook in a single cell. I've tried the following formula but it returns a #VALUE! in my destination cell: ='[Project1.xls]Dependencies'!$A$6, '[Project1.xls]Dependencies'!$A$7 Any ideas on if this is possible? TIA, SamuelT  SignatureSamuelT Use the "&" operator to concatenate texts (or the Concatenate function) SignatureKind regards, Niek Otten > Hi all, > [quoted text clipped - 9 lines] > > SamuelT > ='[Project1.xls]Dependencies'!$A$6, '[Project1.xls]Dependencies'!$A$7 Try something like: ='[Project1.xls]Dependencies'!$A$6 & ", " & '[Project1.xls]Dependencies'!$A$7 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- > Hi all, > [quoted text clipped - 15 lines] > SamuelT's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27501 > View this thread: http://www.excelforum.com/showthread.php?threadid=503954 Thanks guys. I used: ='[Project1.xls]Dependencies'!$B$6& " - " &'[Project1.xls]Dependencies'!$A$6 Much obliged! SamuelT SignatureSamuelT Glad you got what you wanted! Thanks for posting back. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- > Thanks guys. I used: > [quoted text clipped - 10 lines] > SamuelT's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27501 > View this thread: http://www.excelforum.com/showthread.php?threadid=503954 Use ='[Project1.xls]Dependencies'!$A$6 & '[Project1.xls]Dependencies'!$A$7 SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com > Hi all, > [quoted text clipped - 12 lines] > > SamuelT |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.