Hi, There. I'm trying to convert my text in excel to smallcaps automatically but i couldn't find any addin to do so. the only addin that I found was Zan Zac Utilities(www35.websamba.com/zanzac/) which has many other useful features but there is no other help. Thanks

If you know the range the data will be in you could try writing a macro that will put everything in lower case. You could then take that data and move it to another page or paste it over the original range.

A sample to take Cell A1 to lower case is:
    Range("C2").Select
    ActiveCell.FormulaR1C1 = "=LOWER(R[-1]C[-2])"
    Range("C3").Select