Thread: Excel 'Proper' Formula
View Single Post
Old 03-29-2005, 12:01 AM   #8
Kevy Baby
Chowder Head
 
Kevy Baby's Avatar
 
Join Date: Jan 2005
Location: Yes
Posts: 18,500
Kevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of coolKevy Baby is the epitome of cool
Here's another one. I used to know how to do this, but have since lost the formula.

Basically, I want to be able to embed a formula in the middle of a text string. For example, if A1 had "3" and A2 had "4", in A3 you could have "I have (A1+A2) apples" with a result of "I have 7 apples." Except there is a lot more to the formula.

I know it can be done, I just can't remember how.
__________________
The thing about quotes on the internet is that you cannot verify their validity.
- Abraham Lincoln
Kevy Baby is offline   Submit to Quotes Reply With Quote