Hi,
I wrote something recently for another user and the main
problem was that although I created each string in upper
case it does not take into account that one cell had ST
and the other cell had Street. You have to make sure that
rrepeated lines are actually repeats, word for word. Send
me your email and I will send it to you.



- -mark

see my excel stuff:
http://au.geocities.com/excelmarksway
http://www.geocities.com/excelmarksway

-----Original Message-----

Hello,

I have a very big list of adresses and phones. There are
a lot of
repeted data in it.
I would like to know if there is a way to erase the
repeted rows of my
list automaticaly. If it is possible, how can I do it?

Thanks very much.

Matheus


--
gabarrao
----------------------------------------------------------
--------------
gabarrao's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=16885
View this thread:
http://www.excelforum.com/showthread...hreadid=320598

.