Not sure if this is possible, but I am stuck on getting VBA to recognise a specific ID format/layout which lies amongst other text within the cell. The format goes something like "UR-ACA-###", where ### are always 3 numerical digits. I am trying to write a code to make only the IDs bold, leaving the rest of the text in the cell normal.
The model shall follow the protocol as set out in document UR-ACA-020. Failure to do so will result in the model being rejected. See also UR-ACA-300 for more details.
So basically I want the code to find any text in the format "UR-ACA-###" and make only that text in the cell bold. I tried using the Find & Replace function in Excel but that formats the whole cell.
Hope this makes sense! Thanks in advance!