How to spilt information within a cell

I have a ton of information automatically being generated via a report to Excel.

The mass of information is being dumped into cell H on my excel spreadsheet as shown below.

A user account was locked out. Subject: Security ID: S-1-5-18 Account Name: NJAUDBFD01$ Account Domain: ENTERPRISE Logon ID: 0x3e7 Account That Was Locked Out: Security ID: S-1-5-21-1876172974-742851678-1849977318-139445 Account Name: CMKRF Additional Information: Caller Computer Name: 1067899A

I want to separate both Account Name: fields and the Computer Name: field into their own cells, and then I want to generate a script that will provide the count of how many times the "Account Name:" was locked out and which "Computer Name" they were locked out of.

If you need additional information please reply and I will provide it.

I thank you for helping me out.

Excel2012,

Welcome to the Excel Forum.

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, click on the New Post button, then scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.