How to capitalize everything before a certain character?

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,817
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,095,728
Messages
5,446,174
Members
405,389
Latest member
Excel n00b2

This Week's Hot Topics

Top