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

 

[Arts]

There is probably a more efficient way but this worked for me

=RIGHT(E2,LEN(E2)-SEARCH(",",E2)-1)&" "&LEFT(E2,SEARCH(",",E2)-1)

 

[Fluff]

How about

=MAP(E2:E4,LAMBDA(m,TEXTJOIN(" ",,CHOOSECOLS(TRIM(TEXTSPLIT(m,",")),2,1))))

 

[DazCD]

=CONCAT(TEXTAFTER(E2,", ")," ",TEXTBEFORE(E2,","))

In F2 - Dragged down.

 

[zone709]

Thanks guys works great

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[alansidman]

An alternative with Flash Fill

 

[Rick Rothstein]

Why not... here is one more method for the collection

=MID(E2:E4&" "&E2:E4,FIND(",",E2:E4)+2,LEN(E2:E4)-1)

And if you have the LET function available in your version of Excel, this is slightly shorter...

=LET(e,E2:E4,MID(e&" "&e,FIND(",",e)+2,LEN(e)-1))

 

[Tom.Jones]

Or

=TEXTJOIN(" ",,TEXTAFTER(E2,", "),TEXTBEFORE(E2,","))

 

[VinceF]

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