I'm sorry, I can't. It contains private medical information. But I can give an example.

Date Last, First (MRN1234) Med Info
Date Last, First (ABC4321) Med Info
Date2 Last Name, First (BFR0492) Med Info

I want to take what is in parenthesis and format the font to be one size smaller. The problem that I am having is that a macro isn't editing just part of the cell, it is applying the change to the entire cell. Is this enough info?