Splitting One Column Into Multiple Columns

[hycho]

Hi all,

I have an Excel workbook, where a language column has 1 to 5 languages. For example:
Language
Record 1: English
Chinese
Spanish

The 3 languages are separated by hitting the enter key, and not the space bar key. I have about 400 records of this issue.

Is there a way I can split the language column into 5 columns at most? And then, if a record only has 3 languages, only the first 3 columns are populated?

FYI, I have MS Access 2000.

Thanks for your help.

 

[hycho]

Language
English
Spanish
Chinese

 

[hycho]

They're all in one cells.

 

[hycho]

 

[hycho]

How do I insert a screen shot of my computer? I've tried inserting a snippet of the Excel Workbook I am working on.

 

[vbaInet]

How do I insert a screen shot of my computer?

http://www.access-programmers.co.uk/forums/showthread.php?t=194680

 

[hycho]

http://www.access-programmers.co.uk/forums/showthread.php?t=194680

Thanks for the help.