How to capitalize everything before a certain character?

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,923
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,099,164
Messages
5,467,010
Members
406,518
Latest member
SilverSixx

This Week's Hot Topics

Top