Extracting a certain code from a cell using MID function searching multiple criteria

[pedexe90]

Hi everyone,

I'm re posting this as my previous thread was a bit confusing and didn't get any replies.

I would like column D:D to be populated with a function rather than manually. This column contains H codes taken from E:E. The codes are in this format: H0xx-H9xx (4 characters, first character is fixed as H the second character varies from 0 to 9 and the third and fourth characters are random).

I would like one formula to extract the code and return it to column D as seen in the attached file.

You may also enhance my formula, I don't know how to incorporate an OR function to this so. Now it only returns H0xx.

[COLOR=#333333]=IFERROR(MID(E2,SEARCH({"H0","H1","H2","H3","H4","H5","H6","H7","H8","H9"},E2),4),"")[/COLOR]

https://1drv.ms/x/s!AgQdYsSdg735eSFFPKUE3l_bjqM (Attached in One Drive)

Many thanks

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...variable-code-another-column.html#post5075323

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.