How do I change a particular word to all caps and only the first letter of every other word to caps in EXCEL?

Example: Sunny's gift basket needs to show as SUNNY'S Gift Basket.
--------------------
If you want to change a variety of entries (i.e. sunny's gift basket, bob's flowers etc..) that are all in one column, use a formula like what cozmosis suggested. Modify that formula to the following if you need it to work for one word names that have no spaces (i.e. Maria's). =UPPER(LEFT(A2,IF(ISERROR(FIND(" ",A2)), 255, FIND(" ",A2)-1))) & IF(ISERROR(FIND(" ",A2)),""," " & PROPER(MID(A2,FIND(" ", A2)+1, LEN(A2)-FIND(" ", A2)+1))) If "Sunny's gift basket" is the only term you want to change then: >Highlight the entire sheet >Go to: Edit > Replace (or shortcut CTRL+H) >Find what: sunny's gift basket >Replace with: SUNNY's Gift Basket >Select: Replace All
Source