Hello Everyone,

I am facing a problem in data, Our team was managed the data of the customer information they captured the data in capital letter. Now I need to convert that data in proper format.

So my problem is how I change the capital words into proper words. Is there any formula in Excel to convert the text into proper text.

Please suggest.

Thanks
Arpita