How to extract specific data from a cell

[shlomek12]

I am looking to get out from all cells the letters I made in buld out from this cell

https://www.screencast.com/t/apAeD0FCrE6

[TABLE="width: 723"]
<tbody>[TR]
[TD]walgreens.com/store/c/as-seen-on-tv-roll-a-lotion-applicator/ID=prod6095201-product[/TD]
[/TR]
[TR]
[TD]walgreens.com/store/c/the-ove-glove-hot-surface-handler-oven-mitt/ID=prod6021452-product[/TD]
[/TR]
[TR]
[TD]walgreens.com/store/c/finishing-touch-lumina-personal-hair-remover/ID=prod2436909-product

[/TD]
[/TR]
</tbody>[/TABLE]

 

[shlomek12]

I need everything before the X,

CS/PK
40x10
4x9
28x1
12x6
14x1
6x1
-
36x1
24x1
144x1
12x12
224x1
12x12
1x1
1x1


How can I do it

Thanks in Advance

 

[jtakw]

Like this:

Book1
	A	B
1	CS/PK
2	40x10	40
3	4x9	4
4	28x1	28
5	12x6	12
6	14x1	14
7	6x1	6
8	-
9	36x1	36
10	24x1	24
11	144x1	144
12	12x12	12
13	224x1	224
14	12x12	12
15	1x1	1
16	1x1	1
Sheet69

Cell Formulas
Range	Formula
B2	=IFERROR(LEFT(A2,SEARCH("x",A2)-1)+0,"")

Formula copied down, results converted to Real Numbers in case you need to do further math.

 

[shlomek12]

Thanks you so much

Can you please help me with this? I need the next number after "/", So if you please look on the sample below, you will see it mean number 12, but I need only the number

[TABLE="width: 550"]
<colgroup><col></colgroup><tbody>[TR]
[TD]AIR WICK AIR FRESHENER 12/8 oz SNUGGLE FRESH LINEN[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z APPLE CINNAMON MEDLEY[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z FRESH WATERS[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z LAVENDER&CHAMOMILE[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z MAGNOLIA & CHERRY BLOSSOM[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z RAIN GARDEN[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z VANILLA INDULGENCE[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRSHNR 12/8Z HAWAI'I EXOTIC PAPAYA & HIBISCUS FLWR[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Thanks you so much

Can you please help me with this? I need the next number after "/", So if you please look on the sample below, you will see it mean number 12, but I need only the number

[TABLE="width: 550"]
<tbody>[TR]
[TD]AIR WICK AIR FRESHENER 12/8 oz SNUGGLE FRESH LINEN
[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z APPLE CINNAMON MEDLEY
[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z FRESH WATERS
[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z LAVENDER&CHAMOMILE
[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z MAGNOLIA & CHERRY BLOSSOM
[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z RAIN GARDEN
[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRESHENER 12/8Z VANILLA INDULGENCE
[/TD]
[/TR]
[TR]
[TD]AIR WICK AIR FRSHNR 12/8Z HAWAI'I EXOTIC PAPAYA & HIBISCUS FLWR
[/TD]
[/TR]
</tbody>[/TABLE]

See Red above, Do you need the 12, or the 8?
If it's the 8, can it ever be 2 or more digits?

 

[shlomek12]

Yes sorry

I need the 12 ,so it's before the / but sometimes it will be an 12 and sometimes an 8

 

[shlomek12]

??

 

[jtakw]

Here you go, result converted to Real Number:

Book1
	A	B
1	AIR WICK AIR FRESHENER 12/8 oz SNUGGLE FRESH LINEN	12
2	AIR WICK AIR FRESHENER 12/8Z APPLE CINNAMON MEDLEY	12
3	AIR WICK AIR FRESHENER 12/8Z FRESH WATERS	12
4	AIR WICK AIR FRESHENER 12/8Z LAVENDER&CHAMOMILE	12
5	AIR WICK AIR FRESHENER 8/8Z LAVENDER&CHAMOMILE	8
6	AIR WICK AIR FRESHENER 111/8Z MAGNOLIA & CHERRY BLOSSOM	111
7	AIR WICK AIR FRESHENER 12/8Z MAGNOLIA & CHERRY BLOSSOM	12
8	AIR WICK AIR FRESHENER 12/8Z RAIN GARDEN	12
9	AIR WICK AIR FRESHENER 12/8Z VANILLA INDULGENCE	12
10	AIR WICK AIR FRSHNR 12/8Z HAWAI'I EXOTIC PAPAYA & HIBISCUS FLWR	12
Sheet72

Cell Formulas
Range	Formula
B1	=RIGHT(SUBSTITUTE(LEFT(A1,FIND("/",A1)-1)," ",REPT(" ",15)),15)+0

Formula copied down.

 

[shlomek12]

I am getting back the "VALUE error

=RIGHT(SUBSTITUTE(LEFT(A1,FIND("/",A1)-1)," ",REPT(" ",15)),15)+0

Thanks in advance for your help

 

[shlomek12]

I see now my mistake but I still need help

Please look on this Image

https://www.screencast.com/t/1tQUvrfJ

Do you see my problem?

 

[jtakw]

What you have there are LETTERS in front of the /, that was not in any of your samples above, in these cases, what do you need done?