Reference in a text

A

Ant

Is there a way in Execl to say in cell A1 = "InStyle",
B23, "2004"

so i want so text that to refeance a cell and than some
more text.... can that be done?
 
D

DDM

Ant, like this:

="InStyle"&B23&"2004"

You may want to insert some spaces in there somewhere.
 
Top