I have a very large spreadsheet with business names in it. Many are J&j Auto, J&s Transmission Repair, Ss&t Wheels And Tires, and so forth. Using the Proper or Upper function will not accomplish what I am trying to do.
I need a formula that will look in a cell and if it contains *&* then apply the UPPER case to only the letters around the &.
Can this be done?
Bookmarks