Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a cell w/Alpha numeric characters in mulplication formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a cell w/Alpha numeric characters in mulplication formula
With 14.3 in A1 and 185 in B1 enter in C1
=TEXT("["&A1&" hrs @ "&B1,"$##.00")&" /hr]" Gord Dibben MS Excel MVP On Fri, 9 Feb 2007 14:01:00 -0800, 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a cell w/Alpha numeric characters in mulplication formula
"Harlan Grove" wrote...
.... and closer to the OP's specs, ="["&A1&" hrs @ "&B1&"/hr]" .... Make that ="["&A1&" hrs @ $"&B1&"/hr]" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |