Results 1 to 2 of 2

How to spilt information within a cell

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2011
    Location
    Earth
    MS-Off Ver
    Excel 2003
    Posts
    1

    Lightbulb 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.
    Last edited by Excel2012; 06-22-2011 at 02:56 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1