seperate
in [Programming]
|
From: Darrell_Sarrasin via OfficeKB.com on 22 Feb 2010 10:40 I have a report that i get taht I get the persons last name and payroll id in the same cell. the way it shows is as follows: sarrasin [000000] I want to basically run it through programming that will seperate it into two cells. is this posible to do as I have 2000 entries and as you can imagine it can be quite time consumming. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/excel-programming/201002/1
From: Per Jessen on 22 Feb 2010 11:18 If last name and Payroll id is seperated by a 'space', you can use the 'TextToColumns' function on the data menu. Regards, Per On 22 Feb., 16:40, "Darrell_Sarrasin via OfficeKB.com" <u33691(a)uwe> wrote: > I have a report that i get taht I get the persons last name and payroll id in > the same cell. the way it shows is as follows: > > sarrasin [000000] > > I want to basically run it through programming that will seperate it into two > cells. is this posible to do as I have 2000 entries and as you can imagine > it can be quite time consumming. > > -- > Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/201002/1
|
Pages: 1 Prev: Need a UDF to count blank cells Next: too many arguments error message in excel |