$$Excel-Macros$$ Re: PlZ Short This Pro.

2009-07-25 Thread Dilip Pandey
Good Work Mr. Dhananjay, Just a little concern, your solution seems to be like struggling when we have "First Name", "Middle Name" and "Last Name". Would you like to take a look, at the attached file in which I have given a dummy example. I think the "dynamics" is missing here. But once agian..

$$Excel-Macros$$ Re: PlZ Short This Pro.

2009-07-25 Thread Dhananjay Pinjan
Hello Mr. Anil Panchal, This is the better solution on your query. Thanks & Regards, Dhananjay On 7/24/09, anil panchal wrote: > > > > Hi All Frnd & Sr. > > Please find attached file. there is a Full Name Like Anil Kumar Panchal I > want saprate anil kumar panchal in 3 Columns with the help of

$$Excel-Macros$$ Re: PlZ Short This Pro.

2009-07-25 Thread Dilip Pandey
Hi Anil, Please find the solution attached. I have done this using nested function of Excel and given out two different approaches. Thanks, Dilipandey -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 7/24/09

$$Excel-Macros$$ Re: PlZ Short This Pro.

2009-07-24 Thread vivek agrawal
Hi Anil The segregation of the full name into first and second name is based on self judgement in case of 3 word names... how would you like to separate into two names Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Fri, Jul