Mick,
Excel 97 (and maybe 95?) has a REPLACE function much like WORD. Try
EDIT/REPLACE and then the various versions of the names always changing them
to the preferred one.
Frank Harlan
Mick Fitzpatrick wrote:
> At the moment there is 3 methods,
> like this:
>
> MICK FITZPATRICK
> FITZPATRICK Mick
> Ftizpatrick,Mick
>
> I would prefer them all to be like the firtst one. I have been manually
> changing them as I get the time.
> My question is ... is there a way to automate this change?
>
PCSOFT only works if you contribute. Send your messages
to be posted to: [log in to unmask]
|