Prev: Conditional Formatting
Next: Formatting issue
From: Pradeep on 2 Feb 2010 00:06
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
 | 
Pages: 1
Prev: Conditional Formatting
Next: Formatting issue