Replace only abbrevations

[Guest]

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

 

[Peo Sjoblom]

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

 

[Guest]

Use the Spell Checker/Corrector instead:

Tools > Options > Spelling > AtuoCorrect

 

[Guest]

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