not sure if I can explain this correctly, but I'll give it a shot..
I have data in a cell with with either end in a "A", "B", "C", "D" or "E" for example
A
1 GA08150A
(or it could be GA08150B, GA08150C, GA08150D or GA08150E)
the GA will always stay the same, the 08150...