In 2007
Select all columns eg a to d where d is col with duplicates
On ribbon select 'data' tab<'data tools'<'remove duplicates'<
Untick columns a, b,c in new window
Tick box for headers if appropriate
OK





"ComeOn12" wrote:

I need to delete duplicate cells that occur within a row, and return only the
unique cells. There are 4 colums and almost 7000 rows.

Example of rows:
123 Main St Ste 789 123 Main St
987 Elm St 1st Floor 1st Floor Room A
311 West St 311 West St

Need to return across multiple cells:
123 Main St Ste 789
987 Elm St 1st Floor Room A
311 West St

THANKS!