Displaying 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

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

--
Kind regards,

Niek Otten

"SamuelT" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile:
> http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=503954
>

> ='[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
---
"SamuelT" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=503954
>

Thanks guys. I used:

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

Much obliged!

SamuelT

Glad you got what you wanted!
Thanks for posting back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SamuelT" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks guys. I used:
>
> ='[Project1.xls]Dependencies'!$B$6& " - "
> &'[Project1.xls]Dependencies'!$A$6
>
> Much obliged!
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=503954
>

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]...
>
> 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
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile:
> http://www.excelforum.com/member.php...o&userid=27501
> View this thread:
> http://www.excelforum.com/showthread...hreadid=503954
>