extract text from cells

[vbachanger]

Hi guys,

I have the following text, I need to extract. How do I need to change the formula, that the output looks like in column B?

extract.xlsx
	A	B	C
1	G-84/3/095429	84/03	84/3/
2	G-84/30/09542	84/30	84/30
Sheet1

Cell Formulas
Range	Formula
C1:C2	C1	=MID(A1,3,RIGHT(FIND("/",A1)))

THX

 

[Fluff]

Maybe

=MID(A1,3,FIND("^",SUBSTITUTE(A1,"/","^",2))-3)

 

[vbachanger]

Maybe

=MID(A1,3,FIND("^",SUBSTITUTE(A1,"/","^",2))-3)

extract.xlsx
	A	B	C
1	G/84/3/095429	84/03	84
2	G/84/30/09542	84/30	84
Sheet1

Cell Formulas
Range	Formula
C1:C2	C1	=MID(A1,3,FIND("^",SUBSTITUTE(A1,"/","^",2))-3)

Thank you great This works!

What if there are only slashes /in column A?

After the second / is one digit (3), it should show 03 in column B.

Thanks!

 

[Fluff]

Just change the "^",2 to "^",3

 

[vbachanger]

Just change the "^",2 to "^",3

Great

Is it possible to add a zero to single digits after the / (3 ->03) with the formula?

 

[Fluff]

How about

=LET(m,MID(A1,3,FIND("^",SUBSTITUTE(A1,"/","^",3))-3),IF(LEN(m)=4,SUBSTITUTE(m,"/","/0"),m))

 

[vbachanger]

Thank you! Working great!

 

[Fluff]

You're welcome & thanks for the feedback.