Substitution of words

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that has a schedule of when people work and rather than
put the names in (as their job changes every 2-4 weeks), I put in the job,
then every month fill in the correct names from day to day. Is there a way
to subdtitute an entire worksheet name to another (ie written in is "clinic"
in multiple area and for the month of September "Joyce" is the person). Is
there a way to change all places that say "clinic" with "Joyce's" name rather
than going through each day and changing them.
 
Select the range (or the entire sheet), then click Edit > Replace
Find what: clinic
Replace with: Joyce
Click Replace All
 
How about replace?, edit, replace, find what clinic replace with Joyce,
replace all

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Back
Top