I am trying to convert the text from all caps to Caps and lower case better
known as proper text. I used the functions tab and then the formula auditing
box and then select show formula. After that I am lost. Please help

Thanks
Sunny