Hi Roger,

I don't understand. How come you posted before me, but your time says
10:44 when mine says 10:17 and it is only 10;20 now?

Pete

On Jul 6, 10:44 am, "Roger Govier"
wrote:
Hi

One way (work on a copy of your data, just in case you get something
wrong!!)

Insert a new column at B, so you have a blank column to the right of the
Name.
Mark column A, DataText to ColumnsDelimitedmark Comma as
DelimiterFinish.
Delete column B

Mark your range of data, DataFilterAdvanced FilterCopy to new
location and choose a column beyond the end of your existing dataclick
Unique values onlyFinish.
Delete the original columns

--
Regards

Roger Govier

"Baffy" wrote in message

...



An Excel Spreadsheet is set up like this with hundreds of duplicate
names and
addresses:

Name Address City
Zip
Etc.
Smith, Joe 10 S. Oak
Smith, Mary 10 S. Oak

QUESTIONS:
1: How do I eliminate the comma and everything to the right of the
comma for
all records, i.e. ,Joe and , Mary.
2: How do I eliminate duplicate addresses.
My goal is to have one entry as follows:
Name Address
Smith 10 S. Oak
And eliminate duplicate addresses and first name leaving only one last
name
to each address. Can it be done?- Hide quoted text -

- Show quoted text -

Hi Pete

I'm ahead of myself!!!<bg
Twice recently, my time clock has got out of sync, and set itself ahead
of current time.
It was reading 11:52. I forced it to do a time sync with
time.windows.com and it has returned it to the correct time.

Apologies for the confusion.

--
Regards

Roger Govier


"Pete_UK" wrote in message
oups.com...
Hi Roger,

I don't understand. How come you posted before me, but your time says
10:44 when mine says 10:17 and it is only 10;20 now?

Pete

On Jul 6, 10:44 am, "Roger Govier"
wrote:
Hi

One way (work on a copy of your data, just in case you get something
wrong!!)

Insert a new column at B, so you have a blank column to the right of
the
Name.
Mark column A, DataText to ColumnsDelimitedmark Comma as
DelimiterFinish.
Delete column B

Mark your range of data, DataFilterAdvanced FilterCopy to new
location and choose a column beyond the end of your existing
dataclick
Unique values onlyFinish.
Delete the original columns

--
Regards

Roger Govier

"Baffy" wrote in message

...



An Excel Spreadsheet is set up like this with hundreds of duplicate
names and
addresses:

Name Address City
Zip
Etc.
Smith, Joe 10 S. Oak
Smith, Mary 10 S. Oak

QUESTIONS:
1: How do I eliminate the comma and everything to the right of the
comma for
all records, i.e. ,Joe and , Mary.
2: How do I eliminate duplicate addresses.
My goal is to have one entry as follows:
Name Address
Smith 10 S. Oak
And eliminate duplicate addresses and first name leaving only one
last
name
to each address. Can it be done?- Hide quoted text -

- Show quoted text -

Ah, so the time of posting is picked up from each poster's system
time, not from the time maintained by the newsgroups? Learn something
new everyday ...

Thanks Roger.

Pete

On Jul 6, 11:16 am, "Roger Govier"
wrote:
Hi Pete

I'm ahead of myself!!!<bg
Twice recently, my time clock has got out of sync, and set itself ahead
of current time.
It was reading 11:52. I forced it to do a time sync with
time.windows.com and it has returned it to the correct time.

Apologies for the confusion.

--
Regards

Roger Govier

"Pete_UK" wrote in message

oups.com...



Hi Roger,

I don't understand. How come you posted before me, but your time says
10:44 when mine says 10:17 and it is only 10;20 now?

Pete

On Jul 6, 10:44 am, "Roger Govier"
wrote:
Hi

One way (work on a copy of your data, just in case you get something
wrong!!)

Insert a new column at B, so you have a blank column to the right of
the
Name.
Mark column A, DataText to ColumnsDelimitedmark Comma as
DelimiterFinish.
Delete column B

Mark your range of data, DataFilterAdvanced FilterCopy to new
location and choose a column beyond the end of your existing
dataclick
Unique values onlyFinish.
Delete the original columns

--
Regards

Roger Govier

"Baffy" wrote in message

...

An Excel Spreadsheet is set up like this with hundreds of duplicate
names and
addresses:

Name Address City
Zip
Etc.
Smith, Joe 10 S. Oak
Smith, Mary 10 S. Oak

QUESTIONS:
1: How do I eliminate the comma and everything to the right of the
comma for
all records, i.e. ,Joe and , Mary.
2: How do I eliminate duplicate addresses.
My goal is to have one entry as follows:
Name Address
Smith 10 S. Oak
And eliminate duplicate addresses and first name leaving only one
last
name
to each address. Can it be done?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -