Help with Excel macro please

Closed
snejsnej - Feb 17, 2011 at 03:41 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 17, 2011 at 06:37 PM
Hello,

I have a list of names in column A, most rows contain only 1 name.

However, there are also rows in column A that have multiple names separated by a space: "asmith bjohnston sstanley"

In these cases, I'd like to separate the names into their own rows, all in column A. So "asmith bjohnston sstanley" would become:

"asmith"
"bjohnston"
"sstanley"

Can anyone help me out?

Thanks
snej

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 17, 2011 at 06:37 PM
If there is no data in b, c,... etc column, you can use text to column functionality

else u need a macro
0