Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiplying 2 columns- one with numbers only, one with a number &
Is there a way to multiply two columns if one contains text? There is no
limit as to what the number is, however, there is always a space between the number and text. Any help would be GREATLY appreciated. THANKS! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiplying 2 columns- one with numbers only, one with a number &
=1*(LEFT(H1,FIND(" ",H1)-1))
will return the number in a string if the number is first. You can use it in an array formula. -- Regards, Tom Ogilvy "Kel" wrote in message ... Is there a way to multiply two columns if one contains text? There is no limit as to what the number is, however, there is always a space between the number and text. Any help would be GREATLY appreciated. THANKS! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiplying values in columns | New Users to Excel | |||
Multiplying 2 columns with IF | Excel Discussion (Misc queries) | |||
Multiplying one known number with fluctuating numbers in cells | New Users to Excel | |||
Multiplying time values and numbers | Excel Discussion (Misc queries) | |||
multiplying columns | Excel Discussion (Misc queries) |