Extracting first 2 digits from a string of text

[batexcel]

Hello,

Please could someone assist with the following; I need a formula to extract the first 2 digits of a string of text

Col A

MAN BEING 10/200 ASD QQ AZS ENT__1N
WHALE HELPING 15/200 KRE WE GTR ENT__1N
ELEPHANT HOLDING 18/200 KDS RB SOU
HALO CROWN 20/200 QRE DB GTR ENP__2T
PHONE SIM 50/200 QRE DB GTR ENP__2T
MAN ABOVE 90/200 KDS RB RUS PUG 90.00


Col B

I need the first 2 numbers in the string of text

[XLent]

one option

Please Login or Register  to view this content.

if you want to coerce to a number add +0 to end

[AlKey]

Enter formula in B1 and copy down

Please Login or Register  to view this content.

v	A	B
1	MAN BEING 10/200 ASD QQ AZS ENT__1N	10
2	WHALE HELPING 15/200 KRE WE GTR ENT__1N	15
3	ELEPHANT HOLDING 18/200 KDS RB SOU	18
4	HALO CROWN 20/200 QRE DB GTR ENP__2T	20
5	PHONE SIM 50/200 QRE DB GTR ENP__2T	50
6	MAN ABOVE 90/200 KDS RB RUS PUG 90.00	90

Or this

Please Login or Register  to view this content.

[batexcel]

Wonderful. Thank you both so much. How do I make the Col B submit a 3 digit code? so rather than 10 or 15 or 18 etc it reads 010 / 015 / 018

[AlKey]

Try this

Please Login or Register  to view this content.

v	A	B
1	MAN BEING 10/200 ASD QQ AZS ENT__1N	010
2	WHALE HELPING 15/200 KRE WE GTR ENT__1N	015
3	ELEPHANT HOLDING 18/200 KDS RB SOU	018
4	HALO CROWN 20/200 QRE DB GTR ENP__2T	020
5	PHONE SIM 50/200 QRE DB GTR ENP__2T	050
6	MAN ABOVE 90/200 KDS RB RUS PUG 90.00	090

[batexcel]

thank you!