Please help me regarding these below:
1st. How to get all capital letters in a cell. I want to get only the "DEL REY(AM)"
Sample: Alejandro Jay DEL REY(AM)
2nd. How to get the remaining full first name. I want to get only the "Alejandro Jay"