View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default 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?