Need names in order

[mmustkee]

Hi Team,

I have some name which are spelled first name as Capital letter and last name in small letter. There are some cases where we have first name and last name in small letter. so please arrange as per below example.

Name	Result
Saif KOL	KOL/SAIF
Titta SAIT	SAIT/TITTA
sean-tau CONO	CONO/SEAN-TAU
Saif kol	KOL/SAIF
Titta sait	SAIT/TITTA
Fer SABINGH DUMONDT	SABINGH DUMONDT/FER
Laëou  DEBACH FAUD	DEBACH FAUD/'LAEOU
Mich D COLA	COLA D/MICH
Mioult PAN DOR GRA	PAN DOR GRA/MIOULT

[martinding · Accepted solution]

Hi @mmustkee ,

Please check this approach out:

[mmustkee · Accepted solution]

Perfect 

It worked. Thanks a lot for quick response.