Apart from that, you may use Power Query, VBA macros, or third-party add-ins to perform advanced text case formatting. How do I auto capitalize the first letter in Excel? To auto-capitalize the ...