Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | Pujols, Albert | Albert Pujols | ||
2 | LaRussa, Tony | Tony LaRussa | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1) | |
B2 | =RIGHT(A2,LEN(A2)-FIND(",",A2)-1)&" "&LEFT(A2,FIND(",",A2)-1) |
=iferror(right(a1,len(a1)-find(",",a1)-1)&" "&left(a1,find(",",a1)-1),a1)