I need to take the contents of Column A and copy to empty cells when I find a ";". Here is an example of how Column A Row 1 could look: apple; orange; grapes; apple-orange. The result I need is apple orange grapes and apple-orange would each need to appear in a separate cell. It could be in column A or copied to Column B. If we copied to Column B then this is what I would want to see Column B row 1 apple, Column B row 2 orange, Column B row 3 grapes, and Column B row 4 apple-orange. I need to do this for every row in Column A.

Separating the data is easy: Select Column A Click on Data...Text to Columns...Delimited...Next Put a ; in the Other box and click finish. Your description regarding placing the data in B1:B4 confuses me a bit. You said: I need to do this for every row in Column A. If the four parts of A1 will end up in B1:B4, where will the fours parts of A2 end up? Obviously they can't end up in B2:B5, so where will they go?

That worked. The data was copied to the cells b, c, etc (depending on how many ";" appeared in the first cell) of the same row. Thanks

I'm glad I could help. If you need the data in each row to be placed in columns, you can do a Copy...PasteSpecial...Transpose.