I have a list of names, by firstname thensurname (same column). I want to reverse to show Surname, firstname (same column), by using this formula
=RIGHT(B7,(LEN(B7)-(FIND(" ",B7))))&" "&LEFT(B7,(FIND(" ",B7)))
but i also want to add to formula to also change surname to upper case, but leaving first name in lower case. How do I insert this in my formula.
=RIGHT(B7,(LEN(B7)-(FIND(" ",B7))))&" "&LEFT(B7,(FIND(" ",B7)))
but i also want to add to formula to also change surname to upper case, but leaving first name in lower case. How do I insert this in my formula.