I need to reverse the order of the first/last name as well as remove the space between names that have mac in them. So for instance cell C13 contains the name "Elanor Mac Gowan" would need to be changed to "MACGOWAN ELANOR" I also need to make the whole thing upper case
So far I have =UPPER(RIGHT(C13,(LEN(C13)-(FIND(" ",C13))))&" "&LEFT(C13,(FIND(" ",C13))))
Which reverses the names fine.
I also have =SUBSTITUTE(C13,"Mac ", "Mac") However I can't figure out how to merge the two..
Bookmarks