Text after sign need to separate

[DIPASGL]

Hi all

I would like to separate text and number in a cell after hyphen sign, then multiply with quantity.

On left side my description has got 1000l or 20l or .45kg etc sometimes and I want the result as per last column 3000(1000*3) so on - Thanks

DIESEL MAX 15W/40 CK4 - 1000L	3		3000
GEAR OIL 80W/90 - 20L	32		640
HYDRAULIC 32 - 20L	16		320
HYDRAULIC 46 - 20L	32		640
HYDRAULIC 46 - 1000L	2		2000
HYDRAULIC 68 - 1000L	10		10000
HYDRAULIC H 68 - 1000L	1		1000
GREASE LX2 - 0.45KG	640		288
GREASE LXMO2 - 180KG	1		180

 

[Peter_SSs]

Try this

23 06 14.xlsm
	A	B	C
1
2	DIESEL MAX 15W/40 CK4 - 1000L	3	3000
3	GEAR OIL 80W/90 - 20L	32	640
4	HYDRAULIC 32 - 20L	16	320
5	HYDRAULIC 46 - 20L	32	640
6	HYDRAULIC 46 - 1000L	2	2000
7	HYDRAULIC 68 - 1000L	10	10000
8	HYDRAULIC H 68 - 1000L	1	1000
9	GREASE LX2 - 0.45KG	640	288
10	MT BRAKE CLEANER - 400G	96	38.4
11	GEAR SYN - 75W/90 -200g	96	19.2
12	GREASE LXMO2 - 180KG	1	180
DIPASGL (2)

Cell Formulas
Range	Formula
C2:C12	C2	=LEFT(TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",20)),20)),LEN(TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",20)),20)))-2+ISNUMBER(-LEFT(RIGHT(A2,2),1)))/IF(AND(RIGHT(UPPER(A2),1)="G",LEFT(RIGHT(UPPER(A2),2),1)<>"K"),1000,1)*B2

 

[DIPASGL]

Yes Peter, this is something new I am working on. More dashes and with or without space after dash. Do you have solution for this please? Thanks

 

[Peter_SSs]

Do you have solution for this please?

Isn't that a suggestion that I already posted?
Which of those results are incorrect and why?

 

[Peter_SSs]

@DIPASGL
I have removed the 'Mark as solution' from post #13 since that post does not contain a solution. If that was meant to indicate the earlier post contained a suitable solution then you can mark that earlier one. If no post still is what you are after then don't mark any. Thanks.

 

[DIPASGL]

@DIPASGL
I have removed the 'Mark as solution' from post #13 since that post does not contain a solution. If that was meant to indicate the earlier post contained a suitable solution then you can mark that earlier one. If no post still is what you are after then don't mark any. Thanks.

Sure Peter, sorry to be pain but can you help me with below

46.24L

72.34L

22.93L

56.49L

57.11L

43.38L

51.01L

Just want to get right side 46.24, 72.34 so on. I mean want no only but with decimal . Thanks in advance

 

[Peter_SSs]

If the numerical values are 5 characters like all your samples, then

=LEFT(A1,5)+0

 

[DIPASGL]

If the numerical values are 5 characters like all your samples, then

=LEFT(A1,5)+0

Awesome Peter , this worked. Thanks

 

[Peter_SSs]

You're welcome.

I have removed the 'Mark as solution' again. This time from post 18. It is not the answer to the original thread question. Please mark the post that best answered that original question as this will help future readers who are looking for a similar thing.

 

[DIPASGL]

Sure Peter thanks