Extract KB Number from WSUS Excel Report

This content 6 years old. Please, read this page keeping its age in mind along with the fact technology changes fast and the information on this page me be outdated, not best practice, or plain wrong.

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)

Speak Your Mind

*

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