Hi Peeps,
I really need some help on a task I am trying to do on data I have collected in excel.
SMITH, JOHN ----> JOHN SMITH
Above is an example on what I am trying to do in a column (C) of data in excel (2003). I have a list of over 800 records, and I want the first name to be moved to the front on all the records in the column, plus the ‘,’ to be deleted and any spaces removed because of the cutting and pasting. This is so I can create a mail shot to my customers.
I have been racking my brain and it’s got to the stage where I have a mental block I have though, decided that maybe a macro is what I need, but I have no macro know how at all.
Please help
Thanks in advance
Paul
I really need some help on a task I am trying to do on data I have collected in excel.
SMITH, JOHN ----> JOHN SMITH
Above is an example on what I am trying to do in a column (C) of data in excel (2003). I have a list of over 800 records, and I want the first name to be moved to the front on all the records in the column, plus the ‘,’ to be deleted and any spaces removed because of the cutting and pasting. This is so I can create a mail shot to my customers.
I have been racking my brain and it’s got to the stage where I have a mental block I have though, decided that maybe a macro is what I need, but I have no macro know how at all.
Please help
Thanks in advance
Paul