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".

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".

Use the Spell Checker/Corrector instead:

Tools Options Spelling AtuoCorrect
--
Gary''s Student - gsnu200755


"Dano" wrote:

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".

When you are using find and replace, are you entering corp in the find field
and then corporation in the replace field?

"Dano" wrote:

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".