Excel Forum



Excel Magic Trick #190: Rearrange First Last Name w Formula


See how to rearrange three parts in a text string (Last, First, Middle name) using the RIGHT, FIND, LEN, & LEFT functions in one formula.





Got a Question? Ask it Here in the Forum.