SOLUTION ATTACHED
On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote:
>
> Dear Friends,
>
> I am downloading the employee data from our portal. In, there is employee
> name & Emp. ID both are in the same column. I want to split Emp. Name & Emp.
> ID in to two different column. I am also attac
Hi Lavprasad Kori
Pls find the attached file with the solution u want.
Regards,
Deepak Rawat
On Mon, Apr 13, 2009 at 4:54 AM, Lavprasad Kori wrote:
>
> Dear Friends,
>
> I am downloading the employee data from our portal. In, there is employee
> name & Emp. ID both are in the same
As shown in the below article...
http://funwithexcel.blogspot.com/2009/04/sorting-of-dates-with-different-formats.html
use the 'data' tab to split the name and Id. Hope this helps.
On Mon, Apr 13, 2009 at 7:12 AM, Harmeet Singh wrote:
> attached file has the solution
> assuming that ID will be of
Hi Lavprasad
Found a simple solution. Hope it helps.
Regards
Radhe
On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote:
>
> Dear Friends,
>
> I am downloading the employee data from our portal. In, there is employee
> name & Emp. ID both are in the same column. I want to split Emp. Name & Emp
There you go.
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Lavprasad Kori
Sent: Monday, April 13, 2009 5:25 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Help regarding split Emp. Name & Emp. ID
Dear Friends,
Lavprasad Kori- If you add trim function for the name it would remove any
additional unwanted space
On Mon, Apr 13, 2009 at 7:42 PM, Harmeet Singh wrote:
> attached file has the solution
> assuming that ID will be of 5 digits only
>
> On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote:
>
>
Dear Lavprasad,
Please see the attached file with the solution of your problem.
Hope that helps.
Thanks & Regards,
Jitendra Kumar
On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote:
>
> Dear Friends,
>
> I am downloading the employee data from our portal. In, there is employee
> name & Emp.
attached file has the solution
assuming that ID will be of 5 digits only
On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote:
>
> Dear Friends,
>
> I am downloading the employee data from our portal. In, there is employee
> name & Emp. ID both are in the same column. I want to split Emp. Name &
