Formulas with Inititals with Last Name

[mifzal79]

Dear team,

A good day to you all. Attached herewith the list contains of people who are eligible for their medical claim. Column F contains their names.

In some rows, you will find names with inititals and some rows contain their full name. I want to insert a formula where their

FULL NAME SHOULD BE CONVERTED TO INITITALS + LAST NAME.

* If any row is found Inititals + Last name, then not required to convert
* Max characters should be lesser than or equal to 15 characters

Please help me to fix this.

Thanks in advance.

04 - Copy.xlsx
	A
1	Member / Employee Name
2	R W M K W L P KSUBERATHNA
3	K H A N N HETTIARACHCHI
4	NIRANJALA PRIYADARSHANI
5	NIRANJALA PRIYADARSHANI
6	A H L S AMBAGAHAGEDARA
7	A H L S AMBAGAHAGEDARA
8	H D G D S SIRIWARDHANA
9	K B L P K KARUNARATHNA
10	U P A T W KARUNANAYAKA
11	W R P M S P RANASINGHE
12	NILMINI PRIYADARSHANI
13	V A K A L PREMARATHNA
14	W A V DWICKRAMASINGHE
15	W A V DWICKRAMASINGHE
16	H P A M PUSHPAKUMARI
17	H P A M PUSHPAKUMARI
18	H P A M PUSHPAKUMARI
19	J A D B P JAYASINGHE
20	N S MADDHUMAARACHCHI
21	R A S T K RANATHUNGA
22	R R D S L RAJAPAKSHA
23	A A N PRIYADARSHANI
24	A A N PRIYADARSHANI
25	A A S CHANDRAKANTHI
26	P G P PRIYADARSHANI
27	S H I PRIYADARSHANI
28	A A D CHANDRALATHA
29	B L E L BALASURIYA
30	D M N PUSHPAKUMARI
31	DULEEKA PRIYANGANI
32	G M I P MUHANDIRAM
33	K G M K KOTALAWALA
34	M B D S JAYASINGHE
35	MENUKA KEERTHISENA
36	N G KATHRIARACHCHI
37	N G KATHRIARACHCHI
38	N G T D PRIYANGANI
39	N G T D PRIYANGANI
40	R A T D RAMANAYAKA
41	R K L S RATHNAYAKA
42	R M M K RATHNAYAKE
43	W M S MALALASEKARE
44	D U K WANNINAYAKA
45	H A S PRABHASHINI
46	K P N SAMANKUMARI
47	R D D ROOPASINGHE
48	T A N MADHUWANTHI
49	U A PRIYADARSHANI
50	U G H PUSHPALATHA
51	U G H PUSHPALATHA
52	YAMUNA SENADHEERA
53	A M A S KUMUDUNI
54	K D P JAYARATHNE
55	K D P JAYARATHNE
56	K D P JAYARATHNE
57	K D P JAYARATHNE
58	K S K M SEWWANDI
59	M U RMADAMPITIYA
60	P D M RAJAPAKSHA
61	R M D AMARAWATHI
62	W D R WEERAKKODI
63	G D D PRASADANI
64	G L KUSUMAWATHI
65	H R SRIYAKANTHI
66	N D N DARMASENA
67	P W ANURUDDHIKA
68	S A I MADUSHANI
69	S A I MADUSHANI
70	A B S HARSHANI
71	A W C S MENIKE
72	D G A MADUSHAN
73	D L SANDAKELUM
74	D P R SEWWANDI
75	D P R SEWWANDI
76	D P R SEWWANDI
77	D P R SEWWANDI
78	G R N DARSHANI
79	G S DAMAYANTHI
80	H R D DARSHIKA
81	H U ANURUDDIKA
82	Y A P NILANTHI
83	G P C MAURANI
84	H H S JAYAMAL
85	K C P KOTTAGE
86	M ANURUDDHIKA
87	M ANURUDDHIKA
88	M ANURUDDHIKA
89	M P SANDAMALI
90	M W S NILMINI
91	M W S NILMINI
92	P R T DAMMIKA
93	R M A HANSANI
94	S M NISHANTHI
95	S W NISHANTHA
96	S W NISHANTHA
97	U P P NISHANI
98	A G SUNETHRA
99	A G SUNETHRA
100	D A R MALANI
101	D A R MALANI
102	K D KODIKARA
103	L S MADUMALI
104	M T P KUMARI
105	P M PATHMINI
106	R M S MANIKE
107	T S M KUMARI
108	T S M KUMARI
109	D C S SILVA
110	D N SPERERA
111	D N SPERERA
112	D N SPERERA
113	H C S SILWA
114	H C S SILWA
115	W U DILHANI
116	H A KANTHI
117	I N KUMARI
118	K D MONIKA
119	T A RENUKA
120	S SRIDEVI
121	W H SAMAN
122	N R NAIM
TOTAL

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Formulas with Inititals with Last Name
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[mifzal79]

Anyone here to help me please?

 

[Fluff]

What's wrong with the reply you got on ExcelForum?