Hola
I need Excel to sort a column of this = P3002A,P3002B,P3003A,P3003B,P3004A etc into 2 seperate columns of Odds and Evens. Does anyone know a simple VBA script to do this? Or would it be easier just to create the columns using the Ctrl-H function?
Thanks
Sean
I need Excel to sort a column of this = P3002A,P3002B,P3003A,P3003B,P3004A etc into 2 seperate columns of Odds and Evens. Does anyone know a simple VBA script to do this? Or would it be easier just to create the columns using the Ctrl-H function?
Thanks
Sean