T
trammy
In the excel file I have:
123 A5679 REF
A111 ACC
BLOCK 545 A2456
COPY Abbc23
I would like to search for string beginning with "A" and at least 3
numbers following after letter A. Then I want to copy that string to
the new cell.
For example, the first cell, the string I want is A5679
second cell, A111
third cell, A2456
forth cell, there is no string I want
because after letter A, it is not a number.
So in the new sheet, I should have
A5679
A111
A2456
Thanks a lot,
Tammy
123 A5679 REF
A111 ACC
BLOCK 545 A2456
COPY Abbc23
I would like to search for string beginning with "A" and at least 3
numbers following after letter A. Then I want to copy that string to
the new cell.
For example, the first cell, the string I want is A5679
second cell, A111
third cell, A2456
forth cell, there is no string I want
because after letter A, it is not a number.
So in the new sheet, I should have
A5679
A111
A2456
Thanks a lot,
Tammy