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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cell data entering slow! 0
Setting language of a selected text in Office apps. 0
How can the font and size of (all) citation numbers be altered? 1
Visio shape text disappears upon copy paste 1
macro on different reports CTRL+F in formula 2
Footnote references on one page, footnote text on the next 5
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top