Formula Help First name first last name last remove comma

[zone709]

HI i need to flip last name in column E to First name first and remove comma. Anyway also the formula can be in one cell only F thanks.

Positive Pay Upload File10.11.46.csv
	E	F
1	Name	Forumla
2	Agualongo, Giovanni	Giovanni Agualongo
3	Daniel Alcantara, Carlos	Carlos Daniel Alcantara
4	Aguilar, Vicente T	Vicente T Aguilar
Test

 

[alansidman]

Use Flash Fill.

 

[Rick Rothstein]

Sorry for jumping in on this thread...what if I had first and last names without the "," and wanted to just report the persons last name in a cell?

Bob Jones

Bob Barker

Mike Andrewjeski

Thank you,
VinceF
Win10
Office2019

Assuming your names are composed of only two name parts, and assuming your names start in cell A1, this should work in your version of Excel. Put this formula in the first output cell and then copy it down...

=MID(A1,FIND(" ",A1)+1,LEN(A1))

 

[VinceF]

Rick,

Thanks so much...it works perfectly...much appreciated...!