How to extract specific data from a cell

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,230
Office Version
2007
Platform
Windows
Try this

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:8pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:16.16px;" /><col style="width:16.16px;" /><col style="width:309.86px;" /><col style="width:98.85px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:78px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td > </td><td > </td><td style="text-align:left; ">Date: 5/16/2019
<br />Employee  (Number): Smith, Jesse
<br />Call Back Date #1 : 5/16/2019
<br />Call Back Date #2 : 5/16/2019
<br />Call Back Date #3 : 5/16/2019
<br />Additional Follow-Up Required: NO
<br />Follow-Up Date #1 (if appicable): 5/16/2019
<br />Follow-Up Date #2 (if appicable): 5/16/2019
<br />Resolution Details:
<br /></td><td style="text-align:left; "> Smith, Jesse
<br /></td></tr><tr style="height:78px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td > </td><td style="text-align:left; ">Date: 5/16/2019
<br />Employee  (Number):Devine, Justice
<br />Call Back Date #1 : 5/16/2019
<br />Call Back Date #2 : 5/16/2019
<br />Call Back Date #3 : 5/16/2019
<br />Additional Follow-Up Required: NO
<br />Follow-Up Date #1 (if appicable): 5/16/2019
<br />Follow-Up Date #2 (if appicable): 5/16/2019
<br />Resolution Details:
<br /></td><td style="text-align:left; ">Devine, Justice
<br /></td></tr><tr style="height:78px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td > </td><td style="text-align:left; ">Date: 5/16/2019
<br />Employee  (Number):Stark, Tony<br />Call Back Date #1 : 5/16/2019
<br />Call Back Date #2 : 5/16/2019
<br />Call Back Date #3 : 5/16/2019
<br />Additional Follow-Up Required: NO
<br />Follow-Up Date #1 (if appicable): 5/16/2019
<br />Follow-Up Date #2 (if appicable): 5/16/2019
<br />Resolution Details:
<br /></td><td style="text-align:left; ">Stark, Tony<br /></td></tr><tr style="height:78px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td > </td><td style="text-align:left; ">Date: 5/16/2019
<br />Employee  (Number):Williams, Robin<br />Call Back Date #1 : 5/16/2019
<br />Call Back Date #2 : 5/16/2019
<br />Call Back Date #3 : 5/16/2019
<br />Additional Follow-Up Required: NO
<br />Follow-Up Date #1 (if appicable): 5/16/2019
<br />Follow-Up Date #2 (if appicable): 5/16/2019
<br />Resolution Details:
<br /></td><td style="text-align:left; ">Williams, Robin<br /></td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >D2</td><td >=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))</td></tr></table></td></tr></table>
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,230
Office Version
2007
Platform
Windows
Something the editor did, this is the formula

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

mse330

Well-known Member
Joined
Oct 18, 2007
Messages
595
Office Version
365
Platform
Windows
Just another formula if interested …

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

kripper

Board Regular
Joined
Dec 16, 2013
Messages
102
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!
 

mse330

Well-known Member
Joined
Oct 18, 2007
Messages
595
Office Version
365
Platform
Windows
You are most welcome & thanks for the feedback :)
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,230
Office Version
2007
Platform
Windows
I'm glad to help you. Thanks for the feedback.
 

kripper

Board Regular
Joined
Dec 16, 2013
Messages
102
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.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,230
Office Version
2007
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,990
Messages
5,447,777
Members
405,464
Latest member
Jayne125

This Week's Hot Topics

Top