Extracting and Separating Numbers from a string

[Kirbstomp1287]

Hello all,

I am trying to figure out a way to not only extract numbers from a string, but also separate them. The number will have two different configurations it can be input as. The number with always be formatted either 12010 or 12010G15. What I am needed to do is take the first three digits and place them in a separate cell, then take the 4th & 5th digits into another cell, then if there is a number after the G to place that into yet another cell.

Sorry if there is an easy solution to this, I'm fairly noobish with excel lol. Thanks for any help!

-Chris

[Kirbstomp1287]

Disregard!

I have solved my issue!