Extract KB Number from WSUS Excel Report

While reviewing my WSUS reports (exported to Excel) I found that I could streamline extracting the KB article from the exported report using a basic formula in Excel.
width=755
Here’s the excel formula.

=LEFT(RIGHT(D9,10),LEN(RIGHT(D9,10))-1)

Leave a Reply

Your email address will not be published. Required fields are marked *