Rearranging characters in a cell

roelant

New Member
Joined
Sep 20, 2006
Messages
1
I am trying to rearrange the following text string: "last name, first name" into: "first name last name"
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

This will work for simple names (first name, last name only):

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)

Hope that helps,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,721
Members
410,630
Latest member
JFORTH97
Top