Embedding a reference in a cell with normal text.

R

Reggie

Hello,

I would like to enter the following data in a cell:

Standard Deviation (B17)

The B17 reference is the contents of cell B17, which I
would like to have automatically entered without having to
retype it 5 gazilion times.

Thank you very much!

Reg
 
M

Max

One guess ..

Try in say, C17: ="Standard Deviation "&TEXT(B17,"0.000")

(assuming it's to be formatted to 3 dp)
 
M

Max

Just a small refinement to bring it closer to what was posted ..
Try instead: ="Standard Deviation ("&TEXT(B17,"0.000")&")"
 

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

How to refer to a criterie in a cell using excel sum.if function 3
Excel does not accept text format! 0
1st Wed, 1st Sat, 1st Sun 5
How to maintain references when copying lookup formula 2
using a cell's reference to return a value. 3
VB Script reference cells for in current table? 1
Convert number to text as displayed 4
Linking data in MS Word into Excel 5

Top