Account Number Between 2 text.

[Lasantha]

Dear Team,

Could you please help me to capture account number which between "Default Account" and "Class". I need numeric number between those words. See the attached template.

Thank you.
Lasantha.

 

[John Jairo V]

Hi, Lasantha!

You could try this formula:
[A2] : =-LOOKUP(1,-MID(A2,2+FIND(":",A2),ROW($1:$99)))

Blessings!

 

[Lasantha]

Hi, Lasantha!

You could try this formula:
[A2] : =-LOOKUP(1,-MID(A2,2+FIND(":",A2),ROW($1:$99)))

Blessings!

Thank you very much John

 

[bosco_yip]

Or,

=--MID(A2,FIND(":",A2)+2,FIND("Cl",A2)-FIND(":",A2)-3)

Regards
Bosco

 

[Lasantha]

Or,

=--MID(A2,FIND(":",A2)+2,FIND("Cl",A2)-FIND(":",A2)-3)

Regards
Bosco

Thank you Bosco.

 

[NPOKALA]

=MID(A2,((FIND(":",A2,5))+2),(FIND(" ",A2,((FIND(":",A2,5))+2)))-(FIND(":",A2,5))-2)