Hi,

In the Excel 2000, I have a Worksheet like this

1 1 John
2 0 Mary
3 1 Tom
4 0 Jane
5 0 Helen

How do I do to let the data change to

1 M John
2 F Mary
3 M Tom
4 F Jane
5 F Helen

Thanks for help.

Jason