Hi Niek

Good spot.

I suppose another charactistic is that it is a continuous string with no
spaces, and the first 12 characters are always in CAPS followed by a lower
case "l", "h" or "c".

Hope this helps,

Thanks,

Bhupinder
"Niek Otten" wrote:

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.
|