Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

Thread: How to extract specific data from a cell
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,961
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    11 Thread(s)

    Default Re: How to extract specific data from a cell

    Try this

     ABCD
    1    
    2  Date: 5/16/2019

    Employee  (Number): Smith, Jesse

    Call Back Date #1 : 5/16/2019

    Call Back Date #2 : 5/16/2019

    Call Back Date #3 : 5/16/2019

    Additional Follow-Up Required: NO

    Follow-Up Date #1 (if appicable): 5/16/2019

    Follow-Up Date #2 (if appicable): 5/16/2019

    Resolution Details:

    Smith, Jesse

    3  Date: 5/16/2019

    Employee  (Number):Devine, Justice

    Call Back Date #1 : 5/16/2019

    Call Back Date #2 : 5/16/2019

    Call Back Date #3 : 5/16/2019

    Additional Follow-Up Required: NO

    Follow-Up Date #1 (if appicable): 5/16/2019

    Follow-Up Date #2 (if appicable): 5/16/2019

    Resolution Details:

    Devine, Justice

    4  Date: 5/16/2019

    Employee  (Number):Stark, Tony
    Call Back Date #1 : 5/16/2019

    Call Back Date #2 : 5/16/2019

    Call Back Date #3 : 5/16/2019

    Additional Follow-Up Required: NO

    Follow-Up Date #1 (if appicable): 5/16/2019

    Follow-Up Date #2 (if appicable): 5/16/2019

    Resolution Details:

    Stark, Tony
    5  Date: 5/16/2019

    Employee  (Number):Williams, Robin
    Call Back Date #1 : 5/16/2019

    Call Back Date #2 : 5/16/2019

    Call Back Date #3 : 5/16/2019

    Additional Follow-Up Required: NO

    Follow-Up Date #1 (if appicable): 5/16/2019

    Follow-Up Date #2 (if appicable): 5/16/2019

    Resolution Details:

    Williams, Robin

    CellFormula
    D2=TRIM(MID(SUBSTITUTE(SUBSTITUTE(C2,&#3 4;(Number):&#3 4;,REPT(&#3 4; &#3 4;,99)),&#3 4;Call&#3 4;,REPT(&#3 4; &#3 4;,99)),98,98))
    Regards Dante Amor

  2. #12
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,961
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    11 Thread(s)

    Default Re: How to extract specific data from a cell

    Something the editor did, this is the formula

    =TRIM(MID(SUBSTITUTE(SUBSTITUTE(C2,"(Number):",REPT(" ",99)),"Call",REPT(" ",99)),98,98))
    Regards Dante Amor

  3. #13
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    1,960
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: How to extract specific data from a cell

    Quote Originally Posted by kripper View Post
    I am assuming VBA, unfortunately the systems at my work have disabled the VBA to stop malicious code from running.
    Very good rule

    Quote Originally Posted by kripper View Post
    I just have to figure a way for a regular formula to do the same.
    Sure, no problem

    Have a nice day
    I know you know but I forgot my Crystal Ball and don't know what you know



    Post your Excel version (PC / Mac?), also link to shared excel file with representative example of source data and expected result.
    impossible things we do on the spot. for miracles you need to wait for a while

  4. #14
    Board Regular
    Join Date
    Oct 2007
    Location
    Kuwait
    Posts
    427
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to extract specific data from a cell

    Just another formula if interested …

    =MID(A1,FIND("):",A1)+2,FIND("Call",A1)-FIND("):",A1)-2)

    Check the List of BB codes


  5. #15
    Board Regular kripper's Avatar
    Join Date
    Dec 2013
    Location
    Ontario, Canada
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to extract specific data from a cell

    Quote Originally Posted by DanteAmor View Post
    Something the editor did, this is the formula

    =TRIM(MID(SUBSTITUTE(SUBSTITUTE(C2,"(Number):",REPT(" ",99)),"Call",REPT(" ",99)),98,98))
    Thanks my friend, it worked!

  6. #16
    Board Regular kripper's Avatar
    Join Date
    Dec 2013
    Location
    Ontario, Canada
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to extract specific data from a cell

    Quote Originally Posted by mse330 View Post
    Just another formula if interested …

    =MID(A1,FIND("):",A1)+2,FIND("Call",A1)-FIND("):",A1)-2)
    Thank you so much....that did exactly what I was hoping for. Greatly appreciate it.

  7. #17
    Board Regular
    Join Date
    Oct 2007
    Location
    Kuwait
    Posts
    427
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to extract specific data from a cell

    You are most welcome & thanks for the feedback

    Check the List of BB codes


  8. #18
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,961
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    11 Thread(s)

    Default Re: How to extract specific data from a cell

    I'm glad to help you. Thanks for the feedback.
    Regards Dante Amor

  9. #19
    Board Regular kripper's Avatar
    Join Date
    Dec 2013
    Location
    Ontario, Canada
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to extract specific data from a cell

    Quote Originally Posted by DanteAmor View Post
    Something the editor did, this is the formula

    =TRIM(MID(SUBSTITUTE(SUBSTITUTE(C2,"(Number):",REPT(" ",99)),"Call",REPT(" ",99)),98,98))
    I never had the chance to thank you for your assistance last time my friend.
    Unfortunately life happened, and that sort of stopped me in my tracks for a bit.
    Better now, and back at it....and your suggestion was exactly what I was looking for.
    All the best good sir, and thank you so much for the assistance.

  10. #20
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    3,961
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    11 Thread(s)

    Default Re: How to extract specific data from a cell

    Quote Originally Posted by kripper View Post
    I never had the chance to thank you for your assistance last time my friend.
    Unfortunately life happened, and that sort of stopped me in my tracks for a bit.
    Better now, and back at it....and your suggestion was exactly what I was looking for.
    All the best good sir, and thank you so much for the assistance.
    I'm glad to help you. I appreciate your kind comments.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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