If all your fomulas are within a column, try this:

1. Highlight the column
2. Data - Text to Column
3. Choose Delimited and Next
4. Click Other: then key in '
5. Click Finish

Hope this help

--
Message posted from http://www.ExcelForum.com