Question about protecting

[P D Sterling]

I have a task, in which I import a file which has almost no
standardization, other than name|email, and I clean it up doing a lot of
global replace(s).

I ought to know the answer to this, but . . . is there a way that I can
make three columns «unchangeable» while I global replace the rest of the
worksheet. Last go around, I made a worksheet copy with only the index
number, name, and email, then deleted that info from the working copy
and cleaned it up and sewed it back together (fortunately, it worked).

Any advice would be gratefully appreciated.
--

Regards,

P D Sterling
New York, Texas & Texas, New York

 

[JP]

If you highlight the data before doing Find/Replace, it won't touch
any data that isn't selected. That is, in Excel 2003.


HTH,
JP

 

[P D Sterling]

If you highlight the data before doing Find/Replace, it won't touch
any data that isn't selected. That is, in Excel 2003.


HTH,
JP

Thanks for the info. Unfortunately, I am a manic keyboardist, and I want
to say Ctl+A, replace, replace, so I am going to stick with my split
sheet scenario until it fizzles. Just in case Uncle Bill is listening,
it seems not unreasonable to be able to make one part of a sheet
unchangeable and not another, but who am I to say? If I were as smart as
he, I would be giving away money, instead of grubbing for it. Thanks for
the post!


--

Regards,

P D Sterling
New York, Texas & Texas, New York