Replace only abbrevations
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". |
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". |
Replace only abbrevations
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". |
Replace only abbrevations
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". |
All times are GMT +1. The time now is 01:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com