Hi Pinda,

What are the possible delimiters?

Is "eld a8 @l" a code? It is 13 characters and ends with "l"

Or are there other restrictions?

--
Kind regards,

Niek Otten

"Bhupinder Rayat" wrote in message
...
| 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.
|