importing list with commas from WORD, to individual .xls cells?

B

brantty

I am attempting to import a list from Microsoft Word to Excel. My list has
countries seperated by commas. (EX. aruba, bahamas, Belize, etc). How can I
import this list to .xls and have each country have its own cell going from
A2 on down the column?
 
D

Dave Peterson

If that list has less than 256 elements, I'd copy and paste into A1 (of a helper
worksheet).

Then do Data|Text to columns to separate into individual cells.

Then select that row and copy it.

Then select the real cell and edit|paste special|check transpose

(and toss that helper worksheet)
 
Top