Number/Text combination formula
I am not sure I understood your query correctly..If you are looking to find
the result from the data in cell A1; try the below
A1 = 5 Boxes at 5.99
=(LEFT(A1,FIND(" ",A1)-1)+0)*(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT("
",LEN(A1))),LEN(A1)))+0)
If this post helps click Yes
---------------
Jacob Skaria
"donnae" wrote:
How do I create a formula that gives a dollar amount as the ending result in
a cell when the cell that formula is referencing contains numbers and text?
Example 5 Boxes at 5.99= $29.95($0.00 dollar amount being the end result 5
boxes being the number/text cell reference for the formula) Anyhelp anyone
can provide is greatly appreciated!
|