G
Guest
Hi All,
I have text similar to the following..
----------------------------------------------
field b831 B831 write AASLQ0300000l;
PCPACIMTAAABl [B29 ]
field B7 b7 ;
field a8 @latestdate("PCP2EHSEAAAAh", jEnd);
field b8 @if(a8 <jStart, @latest("PCP2EHSEAAAAh", jEnd),
@avg("PCP2EHSEAAAAh", jStart, jEnd));
--------------------------------------------------------
All this code is in column A and I want excel to search through the text and
copy codes (e.g. PCPACIMTAAABl, PCP2EHSEAAAAh) wherever there may be in the
string, into the corresponding row in column B.
These codes all share the following characteristics,
1) they are all 13 characters in length
2) the last character in the code is always either a "l", "h" or a "c".
Is this possible to do using functions such as index, search or find?
Any help at all will be much appreciated. If you need more explanation,
please ask and I will be happily explain things further.
Many Thanks
Pinda.
I have text similar to the following..
----------------------------------------------
field b831 B831 write AASLQ0300000l;
PCPACIMTAAABl [B29 ]
field B7 b7 ;
field a8 @latestdate("PCP2EHSEAAAAh", jEnd);
field b8 @if(a8 <jStart, @latest("PCP2EHSEAAAAh", jEnd),
@avg("PCP2EHSEAAAAh", jStart, jEnd));
--------------------------------------------------------
All this code is in column A and I want excel to search through the text and
copy codes (e.g. PCPACIMTAAABl, PCP2EHSEAAAAh) wherever there may be in the
string, into the corresponding row in column B.
These codes all share the following characteristics,
1) they are all 13 characters in length
2) the last character in the code is always either a "l", "h" or a "c".
Is this possible to do using functions such as index, search or find?
Any help at all will be much appreciated. If you need more explanation,
please ask and I will be happily explain things further.
Many Thanks
Pinda.