Trim Name Uniformly

[Muthukrishnan V]

Try.xlsx
	A	B
1	Excel 365
2	Request Formula for B	Formula for Column B
3	NOT UNIFORM	CORRECTION To:
4	V.Baskar	Baskar V
5	V Muthu	Muthu V
6	K. Ramesh	Ramesh K
7	Suresh.L	Suresh L
8	Kalyan. S	Kalyan S
9	Krishnan T	Krishnan T
10	Karthi,M	Karthi M
11	T.J. Kalyana Raman	Kalyanaraman T J
Sheet2

 

[Cubist]

Assume you made a typo in row 11, try:

Book2
	A	B	C	D
1	Excel 365
2	Request Formula for B	Formula for Column B
3	NOT UNIFORM	CORRECTION To:	Formula	Check
4	V.Baskar	Baskar V	Baskar V	TRUE
5	V Muthu	Muthu V	Muthu V	TRUE
6	K. Ramesh	Ramesh K	Ramesh K	TRUE
7	Suresh.L	Suresh L	Suresh L	TRUE
8	Kalyan. S	Kalyan S	Kalyan S	TRUE
9	Krishnan T	Krishnan T	Krishnan T	TRUE
10	Karthi,M	Karthi M	Karthi M	TRUE
11	T.J. Kalyana Raman	Kalyana Raman T J	Kalyana Raman T J	TRUE
Sheet1

Cell Formulas
Range	Formula
C4:C11	C4	=LET(t,TEXTSPLIT(A4,{".",","," "}),last,IF(LEN(t)=1,t,""),first,UNIQUE(HSTACK(last,t),1,1),TEXTJOIN(" ",,first,last))
D4:D11	D4	=C4=B4

 

[Muthukrishnan V]

Row 11, I would like to show "Kalyanaraman T J". In Row 12, I have R Chandra Sekaran, to be corrected to "Chandrasekaran R". Kindly guide me.

 

[Cubist]

Try (edited):

Book2
	A	B	C	D
1	Excel 365
2	Request Formula for B	Formula for Column B
3	NOT UNIFORM	CORRECTION To:	Formula	Check
4	V.Baskar	Baskar V	Baskar V	TRUE
5	V Muthu	Muthu V	Muthu V	TRUE
6	K. Ramesh	Ramesh K	Ramesh K	TRUE
7	Suresh.L	Suresh L	Suresh L	TRUE
8	Kalyan. S	Kalyan S	Kalyan S	TRUE
9	Krishnan T	Krishnan T	Krishnan T	TRUE
10	Karthi,M	Karthi M	Karthi M	TRUE
11	T.J. Kalyana Raman		Kalyanaraman T J
12	R Chandra Sekaran		Chandrasekaran R
Sheet1

Cell Formulas
Range	Formula
D4:D10	D4	=C4=B4
C4:C12	C4	=LET(t,TEXTSPLIT(A4,{".",","," "}),TEXTJOIN(" ",,PROPER(CONCAT(IF(LEN(t)>1,t,""))),IF(LEN(t)=1,t,"")))

 

[Muthukrishnan V]

Thank you Mr Cubist sir, Works great! I am grateful to our Forum.