Re: $$Excel-Macros$$ Code Help

Hi Mithlesh, Thanks for sending formula..it solve my problem.. Regards Nikhil On Mon, Aug 9, 2010 at 12:15 AM, Mithlesh Sharma wrote: > Hi Nikhil, > > Try this one, will give result in VPS. > > Vishal Pravinchandra Shah > > =LEFT(A1,1)&MID(A1,FIND(" ",A1,1)+1,1)&MID(A1,SEARCH(" ",A1,FIND(" > "

Re: $$Excel-Macros$$ Code Help

Hi Nikhil, Try this one, will give result in VPS. Vishal Pravinchandra Shah =LEFT(A1,1)&MID(A1,FIND(" ",A1,1)+1,1)&MID(A1,SEARCH(" ",A1,FIND(" ",A1,1)+1)+1,1) Regards, Mithlesh Sharma On Sun, Aug 8, 2010 at 7:13 PM, Nikhil Shah wrote: > Hi Friends, > > In Column " A " .. I have written ---

Re: $$Excel-Macros$$ Code Help

Hi Nikhil Insert this code in a standard module Function FirstLetters(rng As Range) As String Dim arrWords Dim I As Long arrWords = Split(rng, " ") If IsArray(arrWords) Then For I = LBound(arrWords) To UBound(arrWords) FirstLetters = FirstLetters & Left(arrWords(I), 1

$$Excel-Macros$$ Code Help

Hi Friends, In Column " A " .. I have written --- > Vishal Pravinchandra Shah . Now I want In Column " B " should be VPSautomatically..I want Formula I want First Letter Of First Name ; First Letter Of Middle Name ; First Letter Of Last Name in one column.. Awaiting Reply.. Thanks Nik