Displaying Multiple Cell Information in Single Cell

[SamuelT]

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

 

[Niek Otten]

Use the "&" operator to concatenate texts (or the Concatenate function)

 

[Max]

='[Project1.xls]Dependencies'!$A$6, '[Project1.xls]Dependencies'!$A$7

Try something like:
='[Project1.xls]Dependencies'!$A$6 & ", " &
'[Project1.xls]Dependencies'!$A$7

 

[SamuelT]

Thanks guys. I used:

='[Project1.xls]Dependencies'!$B$6& " - "
&'[Project1.xls]Dependencies'!$A$6

Much obliged!

SamuelT

 

[Max]

Glad you got what you wanted!
Thanks for posting back.

 

[Chip Pearson]

Use

='[Project1.xls]Dependencies'!$A$6 &
'[Project1.xls]Dependencies'!$A$7


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"SamuelT" <[email protected]>
wrote in message
news:[email protected]...