Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Embedding a reference in a cell with normal text.
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 |
#2
|
|||
|
|||
One guess ..
Try in say, C17: ="Standard Deviation "&TEXT(B17,"0.000") (assuming it's to be formatted to 3 dp) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Reggie" wrote in message ... 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 |
#3
|
|||
|
|||
Just a small refinement to bring it closer to what was posted ..
Try instead: ="Standard Deviation ("&TEXT(B17,"0.000")&")" -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
How do I print all the text in a cell | Excel Discussion (Misc queries) | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |