Home |
Search |
Today's Posts |
#1
|
|||
|
|||
reference the result of a formula in a text formatted cell
I am trying to refernce the result of a formual/calculation cell in a cell
that is formatted for text (the spread sheet contains part numbers, I need to refernce them as text becasue there are other characters besides numbers in them. In this case, a portion of the part number is the result of a calculation (performed in another cell). I need to append the result of the calculation to the end of the text string(numbers and symbols). |
#2
|
|||
|
|||
Try Debra's nice coverage on combining data at her:
http://www.contextures.com/xlCombine01.html -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "jpwinston" wrote in message ... I am trying to refernce the result of a formual/calculation cell in a cell that is formatted for text (the spread sheet contains part numbers, I need to refernce them as text becasue there are other characters besides numbers in them. In this case, a portion of the part number is the result of a calculation (performed in another cell). I need to append the result of the calculation to the end of the text string(numbers and symbols). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell reference in a formula is called | Excel Discussion (Misc queries) | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
cell reference in formula | Excel Worksheet Functions | |||
I there an easy way to find out if any formula reference a cell? | New Users to Excel | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |