Embedding a reference in a cell with normal text.

  • Thread starter Thread starter Reggie
  • Start date Start date
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
 
One guess ..

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

(assuming it's to be formatted to 3 dp)
 
Just a small refinement to bring it closer to what was posted ..
Try instead: ="Standard Deviation ("&TEXT(B17,"0.000")&")"
 
You must log in or register to reply here.

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

Reference the same cell based on tab name 1
Excel Need assistance with modifying a Duplicate declaration. 13
How to maintain references when copying lookup formula 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
Need to create a error message box 4
using a cell's reference to return a value. 3
Need a little help with a formual problem 2
1st Wed, 1st Sat, 1st Sun 5

Back
Top