How to combine FINDing CHAR(42) and CHAR(47) in 1 formula

Hello,

Is it possible to combine two FIND functions in the same cell? Seems only one works, when you add the 2nd one it gives you an error.

Formula in Column R
=IF(AND(ISERR(FIND(CHAR(42),A2,B2)),ISERR(FIND(CHAR(47),A2,B2))),"",
IF(FIND(CHAR(42),A2,B2),MID(A2,B2+1,FIND(CHAR(42),A2,B2)-B2-1),
IF(FIND(CHAR(47),A2,B2),MID(A2,B2+1,LEN(A2)-FIND(CHAR(47),A2,B2)-2))))

A2: Description
B2: Position of Last Space character
Char(42): *
Char(47): /

Description
CocoNara Coconut Chocolate 24*60Pcs
Coco Nara Coconut Chocolate 18/96Pcs
Coco Nara Aya Coconut Chocolate 18/96Pcs
Mighty Mouse Blue Berry Chocolate 12*50gr
Mighty Mouse Blue Berry/Mint Chocolate 10*50gr
Mighty Mouse Grape/Cream Chocolate 10/50gr
Mighty Mouse Grape/Cream Chocolate 1000gr
Mork Strawberry Cream Chocolate 24/10*10

Since I am FINDing asterisk first Row 1, Row 4, Row 5 & Row 6 give correct results, but not others since they have a slash and we are looking for a slash in same formula

Any help would be very much appreciated. If you need a sample file, I will be glad to upload it.

Warmest regards,
RJ

I thought I did attach the worksheet, but .....

So here it is. Sorry for the confusion.

I am trying to extract the size and the case packing.

again thank you for your help.

Originally Posted by Richard Buttrey

Hi,

What's the aim here.

Is it
1. Strip out the Description only (i.e. ignoring the quantity)
2. Strip out the quantity, e.g. 24*60Pcs
3. Find the position of either the "*" or "/" character

Thank you for your help, I did attach the file.

Originally Posted by Glenn Kennedy

What do you want to get as the results?

Trying to extract size and packing, I am able to extract size but not packing.

Thank you for your help.

Thank you AlKey for your help. If you could kindly explain the formulas in column Q & R it would help me maybe eliminate my "helper" columns all together for other columns.

Hi Richard,

Thank you for your help. If you could kindly explain the formula I could maybe use it in other worksheets.