Dear Udo, thanks for your input. However, your solution I think assumes
that the year digit will always be in the last position or at least
consitently placed. What I have here is some 500 entris and some 100 people
inputing this field. You won't believe how many variation of the wording and
style occurs here. So I need a more clever formula .

Ibrahim solution is getting closer to what I need I thnik?

Best regards and thanks for your input.

Speedy.

"Udo" wrote:

Suggestion:
in another row you have the following formula per line:
=if(right(A1;1)="6";"";A1)
Then there will be an entry only when the text refers to 2006,
otherwise this cell appears to be empty. After sorting the data
according to this column you will get the desired result.

Good luck
Udo