Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to add a dot........please help
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 |