![]() |
Want to add a dot in between to Names
Hi,
I have a huge data of customers names. I want to take out the first letter of each word in the name and add with a dot. Is there any formula? Example:- Tiger Woods as T.W. Sachin Tendulkar R as S.T.R. Adam John Gilly as A.J.G. Pointing Jr. as P.Jr. -- Thanks and all your help will be much appriciated |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com