Hi,

Enter this formula in cell F2

=IF(ISNUMBER(F1),"R","")

Enter this formula in cell F3

=IF(ISNUMBER(F1),F1,"")

Regards

Govind.

Claude Laframboise wrote:
I have 21 different team from 1 to 21. everytime a number appear in column,
ex: F1=5, then I would like to have in F2 the letter "R", and in F3 the
number "5"
could someone please let me know if it is possible to do this.