Get series of values from a range of values

Namaskar Experts
I am trying to create and extract a series from the huge number of rows of data. With the help of a code, I am trying to get the result in column F from the values in column D as shown in the workbook. I hope someone can help me with a code to solve this.
TYIA

Must it be code or is formula also acceptable?

Originally Posted by FlameRetired

Must it be code or is formula also acceptable?

FlameRetired. I require a code, but if you are able to write a formula and if you get it right, then I hope someone can convert the same into VBA code.

Please Login or Register  to view this content.

If either of the first 2 characters is an alphabet, it will loops through each character of the value and get only the alphabets to the extracted value. (In case of 2T, 2 is a number T is an alphabet so it should take 2T1 Left D2,3) It should stop appending characters once a number is encountered in the first 2 characters, it should set the extracted value Left D2,8

Thank You Jindon. Run Time Error 9. Subscription out of range at this line
If x(0) Like "[!0-9][!0-9]*" Then
The code is displaying the correct results but with an error message. How do I avoid that message.?

This is the code you shared. I repeat that the result is correct but facing an error message box in the end.

I wonder why it displayed the error message the last time I checked. Now it is not showing. It is alright now. Thanks Jindon.