Hi There
Please assist me in the below.
I use to be able to make use of the =Substitute formula but cant seem to find anything on google.
29 BIRD ST T17198
42ND HILL ATL T19459
ACACIAVILLE POWER T10371
ACCACIAVALE VC T10414
ALLEN STREET VC T5953
ALLWEAR INDUSTRIAL T3674
All the above lines is in its own cell, Now I want to extract all the "T" which is connected to the numbers.
So my results should be
T17198
T19459
T10371
T10414
T5953
T3674
i keep on thinking it was something like
But it does not work.
Bookmarks