| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add two cells from seperate work sheets into a cell on seperate wo | Excel Worksheet Functions | |||
| How seperate text with comma in a cell into seperate rows | Excel Programming | |||
| How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
Linear Mode
