Using a cell w/Alpha numeric characters in mulplication formula
Here's a couple formulas to extract the hours and dollars from your data.
=VALUE(MID(A16,2,FIND(" ",A16)-2))
=VALUE(MID(A16,FIND("$",A16)+1,FIND("/",A16)-FIND("$",A16)-1))
Is that something you can work with?
HTH,
Elkar
"MAJ0116" wrote:
Trying to create multple rows with each showing
[14.3 hrs @ $185/hr] (each row different hours and $rate)
It's necessary for us to have the brackets showing, but a cell with [14.3 in
it is not recognized as a number - same thing applies to the $185/hr
Appreciate any assist
|