Jake Wiley wrote:
Hi I have a worksheet with a column of goals (for teachers) and some
directions. For example:
1) Student work samples - A sample of student work needs to be
presented and dated.
This is all in one cell
2) Parent Involvement Folder - Proof of parent consent must be
presented
and so on and so on
I just need:
Student work samples
Parent Involvement Folder


I wouldn't use VBA if you just need to do it once. Create an empty column to
the right of this column. Highlight the column with the text and choose
Text To Columns from the Data menu. Split the text based on a hyphen
delimeter. Delete the new column.

--
Dick Kusleika
MVP-Excel
www.dailydoseofexcel.com