Say I have these two lines in Column A:
3051S2TG4A2A11X5AWA3WK1I5A1140
3051S2LD2AA1A1030DFF71CA00
I need to be able to have a formula in Column B that Finds the letter "A" when it is followed by four numbers, and then return "A and the 4 numbers."
So for the first line, the result in Column B would be "A1140," and the second line result would be "A1030"
Any help would be much appreciated.
Thanks,
J
3051S2TG4A2A11X5AWA3WK1I5A1140
3051S2LD2AA1A1030DFF71CA00
I need to be able to have a formula in Column B that Finds the letter "A" when it is followed by four numbers, and then return "A and the 4 numbers."
So for the first line, the result in Column B would be "A1140," and the second line result would be "A1030"
Any help would be much appreciated.
Thanks,
J