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

1. ## Re: How to extract specific data from a cell

Try this

 A B C D 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, TonyCall 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, RobinCall 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

 Cell Formula D2 =TRIM(MID(SUBSTITUTE(SUBSTITUTE(C2, 4;(Number): 4;,REPT( 4;  4;,99)), 4;Call 4;,REPT( 4;  4;,99)),98,98))

2. ## 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))

3. ## Re: How to extract specific data from a cell

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

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

Have a nice day

4. ## 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)

5. ## Re: How to extract specific data from a cell

Originally Posted by DanteAmor
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. ## Re: How to extract specific data from a cell

Originally Posted by mse330
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. ## Re: How to extract specific data from a cell

You are most welcome & thanks for the feedback

9. ## Re: How to extract specific data from a cell

Originally Posted by DanteAmor
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. ## Re: How to extract specific data from a cell

Originally Posted by kripper
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.