+ Reply to Thread
Results 1 to 4 of 4

I need to Pull multiple similar data from one single cell and extract into diffrent colums

  1. #1
    Registered User
    Join Date
    01-30-2013
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Exclamation I need to Pull multiple similar data from one single cell and extract into diffrent colums

    I have been put on a project to extract details from one single cell and put it into other cells to create a pivot table. Sounds easy however the data from this one cell can vary from 1 time to being seen 15 times in one single cell. How do I extract just the data I'm looking for after the first set is extracted? what piece of my data am I missing from my formula? let me give you an example below.

    the data looks like this:
    Oper: YW Date: 12/14/12 9:39am
    mortgagee cls to sign, e-amiled to debbie for signature, also
    just another correction april

    Oper: KB Date: 01/21/13 11:55am
    emailed for signature again.

    Oper: KB Date: 01/22/13 10:38am
    rcvd signed - emailed to company through website for processing.


    =MID(AQ2,SEARCH("Oper:",AQ2,1)+6,3) Gave me the first Oper: KB /for the date same thing, but the others? please help


    and I need to only extract the "Oper: ID" and the "Date:: into two diffrent colunms , one colunm per sequence of Oper: ID and Date. I was able to do the first one no problem using this formula: =MID(AQ2,SEARCH("Oper:",AQ2,1)+6,3) which gave me the ID for the first occurance in the cell but what about the 2nd or the 3rd as shown above? how do I get that out of this single cell using a regular formula, no vba or scrubbing?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: I need to Pull multiple similar data from one single cell and extract into diffrent co

    have you tried text to column?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    01-30-2013
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: I need to Pull multiple similar data from one single cell and extract into diffrent co

    I did and it only extracts the 1st set of info. Everything else just erases?

  4. #4
    Registered User
    Join Date
    01-30-2013
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: I need to Pull multiple similar data from one single cell and extract into diffrent co

    My other problem is the fact that all these "notes" are diffrent sizes and the spaces are diffrent also , so the text to columns looks nightmarish...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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