Using a cell w/Alpha numeric characters in mulplication formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
With 14.3 in A1 and 185 in B1 enter in C1

=TEXT("["&A1&" hrs @ "&B1,"$##.00")&" /hr]"


Gord Dibben MS Excel MVP
 
Gord Dibben said:
With 14.3 in A1 and 185 in B1 enter in C1

=TEXT("["&A1&" hrs @ "&B1,"$##.00")&" /hr]"
Click to expand...
....

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble adding timesheet formulas 1
Prevent alpha character from being entered into a numeric field 3
Get "####" when use alpha char in a cell referenced by a formula 5
Parsing a alpha character out of a cell 7
SUMPRODUCT formula help?? 1
Timesheet formula problem 2
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highe 1
find and replace numeric strings in larger text strings 8

Back
Top