Latest Lists

Is there an easy way to convert a long list of comma-separated words to an unordered list?

I am trying to convert a 3 page long list of comma-separated color names to an unordered HTML list. Is there any easy way to do it within MS Word or any other source? It would take me countless hours otherwise.

Public Comments

1. Use MS Excel. There's a function that will allow you to seperate the data into seperate columns. Go to the data menu and select "Text to columns". It even has an option for you to use the commas to seperate each field.
2. The best way is to select the data that you want to arrange in an unordered manner (in MSWord) and in the table menu click on "covert text to table". By selecting comma as the seperator, you can covert all you text into a table (with number of columns as your preference) and either sort it, or normally transger fragments of the table in an un-organized manner. You can then convert back the table to text in the same "table" menu, and insteat of the comman, you can use any other mark, like tab or new line for each cell.
3. You can do it in MS Word or Notepad. GO to Edit>Find and Replace. This allows you to find something in the text and replace it w/ something else. Replace "," with "</li><li>" and click Replace All. At the beginning put <ul><li>. At the end put </li></ul>. Voila!
4. Download Textpad (text editor), it allows to record macros. You only need to start the macro recorder, search for a comma, delete it, and press Enter, stop the recorder, save the macro. Then you only execute the macro on all your text and every comma will get ovewritten with an Enter (new line). I'm sure Excel can do it also - no info on that.
5. I totally I agree with discoasimo, and his/her answer is the best way to achieve your requirement. Remember, you have to save the replaced file as HTML.