seperate
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.a...mming/201002/1 |
seperate
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@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 |
All times are GMT +1. The time now is 01:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com