Need help Converting Code to Read Alpha Numeric Legends instead of single character legend

This code below automates a process for me with single digit characters 0 through 9 and A through Z legends. I would now like it to work with Legends which are Just Letters Alone or Letters accompanied by a number. So For Example Legend "OVRV1" in the current code would read the legends as O, V, R, V, 1. The way the new code would behave would read it as O,V,R, V1
Legends are an alphabet letter alone or an alphabet accompanied by a letter. It should understand that V1 is not V even though V is contained in V1. Any Help Would be Great.

Including a file below which should explain what the macro currently does and what i need it to do , this should help clear out any issues. The Code below is the original code.

It should be noted the code pulls legends verbiage from its corresponding Legend in Column B. If the Legend has a Dash in it for example ORV-D1H the legends D,1, and H pull verbiage from the orange area and the O, R V Legends from the Light Green Area. Running the macro in the example file will clear any confusion.

Please Login or Register  to view this content.

So
ORV2N-WABH is read as O, R, V2, N, W, A, B, H
And
ORVPRST-AB1H2FE is read as O, R, V, P, R, S , T, A, B1, H2, F, E?

I feel like I am missing something,

Hello donnydorko,

I have added the macro below to the attached workbook. Check it out and let me know if anything needs adjusting.

Please Login or Register  to view this content.

Hello donnydorko,

Glad it works. If there is anything about the code you want explained, just ask.