•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Extract the UPPERCASE name or surname
I have names like this in one column:
PAUL Hughes
Zachary COX
Alan Murphy
Donald M NelSON
BILLY JEAN KING
I want the result to look like this in a different column:
PAUL
COX
(empty)
M
BILLY JEAN KING
I really don't know how to do this. please help!!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives