Can I insert Cell ref into text output

J

Jamie

Hi There

I think this is possible. I am using an If Statement to
output text to a cell. i.e "Jamie is leading by __
points."

Is it possible to insert a Cell reference, where I have
put __ into the text output?

Any help greatly appreciated

Cheers in advance

Jamie
 
O

Ole Michelsen

="Jamie is leading by " & D1 & " points."
or the function concatanate.

Ole
 

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

Link a text box based on drop down box with four options MS Word 365 0
Word OLE to check spelling in text box 1
Dragging a formula down isn't working - where am I going wrong? 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Locating differences in text when comparing two cells 10
Converting URLs in comments to Markdown-formatted links 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2

Top