Mykasd
10-15-2007, 01:02 PM
If I have a list of words in a cell and want to separate them in to other cells, how would I do that? These words are separated by commas within a certain cell and I want them to be in different cells.
For example:
Cell A1 contains: Mike, John, Pete, Sarah
And I would like a macro to split this list so that:
B1 contains: Mike
C1 contains: John
D1 contains: Pete
E1 contains: Sarah
Can anyone help?
For example:
Cell A1 contains: Mike, John, Pete, Sarah
And I would like a macro to split this list so that:
B1 contains: Mike
C1 contains: John
D1 contains: Pete
E1 contains: Sarah
Can anyone help?