Good Afternoon Excel Gurus,
Need help from the gurus with a quick formula to achieve the following result.
Column A has Names that I am trying to change to match the results as shown in column B.
<tbody>
A
B
A1
INSP-6
INSP-00006
A2
INSP-16
INSP-00016
A3
INSP-116
INSP-00116
A4...