Thanks, now I feel like an idiot :) [I think I would have thought of this myself if I had not been trying to use regular expressions :>]
On 8/12/05, Anthony Chilco <[EMAIL PROTECTED]> wrote: > > Hi David, > I do this regularly by filling the column next to the data (assumed to > be in column 'A') with this formula: > =If(A1=A2;"";A1) > This results in a column of unique entries. I copy it, paste special / > data only, then sort. > tc > > David Rudel wrote: > > >Hey guys, how can I use "Find and Replace" to find instances of two > adjacent > >cells having identical content? > > In particular, I am trying to figure out how to use regular expression > to > >take a sorted list and delete identical entries: > > So > > A > >A > >A > >B > >C > >CC > >D > >D > >EEE > >F > >F > > Would become > >A > >B > >C > >CC > >D > >EEE > >F > > Any help would be appreciated. > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
