Hi

I'm on a Mac with Excel 2008
I have a contact list with 6000 rows, I need to alter the data in two columns - 'contact name' and 'position' where there is more than one line of data in a cell.

For example...

If ROW 1, COLUMN A contains the following:
Mr Smith
Mrs Smith

and ROW 1, COLUMN B contains
Director
Sales Manager

I would like to delete Mrs Smith and Sales Manager. I'm hoping there is a formula that can find all cells with a return or multiple lines and delete the second line?