Find and mid function usage problem

[Willingtolearnsmthng]

Hi everyone,
This is my first question for this forum. Thanks a lot in advance for your help.
As I showed you in the image, I have to find the 2 numbers right of H. I have tried some formulas but I could not. Like this:

==FIND(Workings_1!C2,MID(Workings_1!C2,3,2))

How can I solve this?

 

[6StringJazzer]

Your image is a little confusing because you didn't give us an example result.

Maybe this:

=MID(Workings_1!C2, FIND("H", Workings_1!C2)+1, 2)

 

[Willingtolearnsmthng]

That worked perfectly but I have a question. Why you didn't use the firstly FIND function and why did put +1?

 

[6StringJazzer]

Why you didn't use the firstly FIND function

I assume you mean, "Why isn't the FIND function in the first argument?"

The arguments to the MID function are

MID(text, startnum, numchar) where
text is the full text string--the full string in C2
startnum is the first character for the substring--we find the "H" by using the FIND function to get startnum
numchar is the number of characters for the substring--2 because you want 2 digits

why did put +1?

The function FIND finds the "H" but you want to start with the first character after the H.