How to capitalize everything before a certain character?

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,905
Office Version
2010
Platform
Windows
Peter_SSs, that worked. I appreciate the help!
I am still wondering what the "rule" that I asked you about in Message #18 is. On the second "rule" question I asked, I was thinking about names like DreamWorks, SportsZone, CompuServe, etc.
 

Watch MrExcel Video

Forum statistics

Threads
1,098,998
Messages
5,465,897
Members
406,453
Latest member
CeReaLK

This Week's Hot Topics

Top