Using a cell w/Alpha numeric characters in mulplication formula
Gord Dibben <gorddibbATshawDOTca wrote...
With 14.3 in A1 and 185 in B1 enter in C1
=TEXT("["&A1&" hrs @ "&B1,"$##.00")&" /hr]"
....
This returns
[14.3 hrs @ 185 /hr]
but so would
="["&A1&" hrs @ "&B1&" /hr]"
and closer to the OP's specs,
="["&A1&" hrs @ "&B1&"/hr]"
Why bother with the TEXT call?
|