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 *

This site uses Akismet to reduce spam. Learn how your comment data is processed.