View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pradeep Pradeep is offline
external usenet poster
 
Posts: 17
Default 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