Originally Posted By: wfaulk
You have to put it in a separate cell. There's no way to modify the existing cell, AFAIK.


This is the last time I will ever be so naive as to think my Excel question might be simple! smile

Anyway, I went to my Excel Guru Extraordinaire (does anyone besides me feel the absence of Paul Grzelak on this bbs?) and here is the answer:

=IF(RIGHT(B3,2)="ar",LEFT(B3,LEN(B3)-2)&"áis",IF(RIGHT(B3,2)="er",LEFT(B3,LEN(B3)-2)
&"éis",IF(RIGHT(B3,2)="ir",LEFT(B3,LEN(B3)-2)&"ís","Notstandard")))

the key elements I was lacking being the "(LEN(B3 -2)" conceept, and the "&" function for appending the áis etc. suffixes.

Now I just have to work out how I am going to put the formula in its 18 variations (for 1st, 2nd, 3rd person singular and plural in present, past, and future tenses) into the spreadsheet in such a fashion that I can copy it and have the "B3" update to B7, B11, B15 etc. and still allow me to sort the list. Never mind, don't try to visualize that, without seeing the actual spreadsheet you can't make any sense of that.

At least now the problems are in the realm that I can understand.

tanstaafl.
_________________________
"There Ain't No Such Thing As A Free Lunch"