I am trying to take a list from word and put each item on a row in excel. Is there a formula or conversation that can accomplish this? See example below:
Currently in Word Doc as:
Smith, jones, april johson, beth tibbet, ariel clark
Want it to look like this in excel:
Column (across) =
Row (down) A B C
1 Smith
2 Jones
3 april johson
4 beth tibbet
5 ariel clark
Thanks
Bookmarks