Literal on Cell Reference

[Guest]

I would like to tag a cell reference with an identifying field literal.

For Example....

Customer Name: John Doe

Where I thought the formula would be...

Customer Name:'Cust Info'!E9

Can I tag a cell reference with a preceding literal identifying it as such???

I appreciate this Discussion Group!

Thanks!

 

[Frank Kabel]

Hi
try:
="Customer Name: " & 'Cust Info'!E9