Russell 2000 Membership List in Spreadsheet format (updated)

My last post on the membership list generated some positive feedback, but it appears that it needs an update.

I'm posting the steps I took to convert the index's PDF-only list to an Excel spreadsheet in case anyone else would like to have a go at updating in the future...

1. Download and open the Rusell 2000 membership list in Adobe Acrobat Reader.

2. Do an Edit/Select-All and Edit/copy to the clipboard.

3.  Open an new Excel (or on my case OpenOffice Calc) spreadsheet, and Edit/Paste the contents of the clipboard to the blank sheet. You should get a column full of company names and ticker symbols combined into a column of single cells.

4.  To extract the symbol (basically the last word of the cell), use the following formula in a new column to the right:

=RIGHT(A4,LEN(A4)-FIND("*",SUBSTITUTE(A4," ","*",LEN(A4)-LEN(SUBSTITUTE(A4," ","")))))

  assuming the start of your symbols are in cell A4, post this in colum B4 or C4

5.  Copy/paste this formula all the way down your sheet to get a list of ticker symbols.

The results of the above steps can be seen/downloaded at this google spreadsheet:

https://docs.google.com/spreadsheet/ccc?key=0AjjUvzIcIusUdExDTFNOY21pOGNGQTVLcWJKS2lEcGc

I hope this helps all you who commented on the earlier post.