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

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?

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)

brantty wrote:

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?

--

Dave Peterson