Replace only abbrevations
Dano,
are these part of a larger string or are they the only string in the cell
e.g.
Corp
or
Corp blabla
if the only word in the cell you can click options when the replace box pops
up and select "Match entire cell contents"
if they are part of a larger string then presumably there would be a space
after Corp then you could include that space in the search and replace. Note
if that's the case then you must make sure "Match entire cell contents" is
not selected
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
"Dano" wrote in message
...
I am working with some very long lists and trying to match data. I would
like
to use the replace function to change "Corp" to "Corporation". However,
when
I do It changes all the "Corporation" to "Corporationoration".
|