Shorten Description

Curious

Board Regular
Joined
Aug 22, 2003
Messages
77
Happy Thanksgiving every one.

I have spread sheet that has several columns including a description column. The are some rows that the description column is more than 80 characters. I would like be able to creat another row with with all the same data in all the other columns in the row but then break the description column in smaller column.

Please see the following example

Before



<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Occur_Number</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim_number</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Id_Number</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Note_Date_Time</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Note_Type</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Subject</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>User_ID</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Note</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Note_Level</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3005</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-09-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Lucia Aguirre, Individually and as Next Friend of Joanna Aguirre and Jorge Luis Aguirre, and Oscar L. Aguirre and Martha Aguirre, Individually and as Next Friend of Karina Priscilla Aguirre vs. Maverick County Hospital District d/b/a Maverick County Hospital and/or d/b/a Fort Duncan Medical Center, Antonio Gallegos, MD; Sebastian Padron MD; and Celedonio De La Cruz MD</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3006</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-09-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>David Eiland and Theresa Eiland, Individually and as next friend of Corey Eiland , a Minor vs. Merrimon W. Baker MD; and Baptist Hospital, Liberty</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3020</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Zenon Garza, JR, Individually and as surviving spouse and Representative of the Estate of Kim Jomsoon Lara, Deceased, Juan Remijio Lara, Carolina Lara, Individually and as next friend of Kim Ann Lara, Cynthia Annett Lara and Zenon Garza III, Minor Children of Kim Jomsoon Lara, Deceased vs. Jan W. Buettgen MD; Ruben Gomez MD; Starr County Memorial Hospital, Mario M. Jiminez MD; and Family Health Center of Rio Grande City, PA</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3021</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>000</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>51 yr old male fell from roof. treated in er & released. later diag. with fracture at c1. failure to diagnose</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3021</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LD</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>51 yr old male fell from roof. treated in er & released. later diag. with fracture at c1. failure to diagnose</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3022</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>000</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>46 yr old female underwent back surgery, complications during surgery, followed by transfer & extended hosp st</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3022</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LD</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>46 yr old female underwent back surgery, complications during surgery, followed by transfer & extended hosp st</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3022</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Linda S. Gillespie Eakins and Amber Dawn Gillespie vs. Dallas Speciality Hospital Limited Partnership d/b/a Dallas Speciality Hospital, Dallas Spine Group, P.A., David K. Selby, M.D., Robert James Henderson, M.D., Robert James Henderson, M.D.,P.A., Robert Paul Fischer, M.D., Ben J. Tittle, M.D., and Ben J. Tittle, M.D., P.A.</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3023</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>000</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>76 yr old female tx in er w/foreign object in throat. underwent scope procedure. claims lacerated esophagus</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3023</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LD</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>76 yr old female tx in er w/foreign object in throat. underwent scope procedure. claims lacerated esophagus</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3023</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Carolyn Tillery, Individually and as Executrix of the Estate of Mary Lou Riba, Deceased vs. Dr. Raleigh Smith and Hill County Memorial Hospital</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3024</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>000</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>48 yo female tx in er and rushed to surgery. dx with a ruptured liver and transferred by air ambulance</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3024</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LD</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>48 yo female tx in er and rushed to surgery. dx with a ruptured liver and transferred by air ambulance</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3024</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Christina De Luna vs. Anand K. Mittal MD; Antonio Gallegos MD; Antonio Gallegos MD, PA Inc; Sebastian Padron, MD; and Maverick County Hospital District, d/b/a Maverick County Hospital (now knows as Fort Duncan Medical Center)</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
</table>


After



<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Occur_Number</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim_number</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Id_Number</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Note_Date_Time</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Note_Type</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Subject</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>User_ID</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Note</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Note_Level</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3005</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-09-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Lucia Aguirre, Individually and as Next Friend of Joanna Aguirre and Jorge Luis Aguirre, and Oscar L. Aguirre and Martha Aguirre, Individually</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3005</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-09-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr> and as Next Friend of Karina Priscilla Aguirre vs. Maverick County Hospital District d/b/a Maverick County</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3005</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-09-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Hospital and/or d/b/a Fort Duncan Medical Center, Antonio Gallegos, MD; Sebastian Padron MD; and Celedonio De La Cruz MD</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3006</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-09-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>David Eiland and Theresa Eiland, Individually and as next friend of Corey Eiland , a Minor vs. Merrimon W. Baker MD; and Baptist Hospital, Liberty</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3020</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Zenon Garza, JR, Individually and as surviving spouse and Representative of the Estate of Kim Jomsoon Lara, Deceased,</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3020</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Juan Remijio Lara, Carolina Lara, Individually and as next friend of Kim Ann Lara, Cynthia Annett Lara and Zenon Garza III,</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3020</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Minor Children of Kim Jomsoon Lara, Deceased vs. Jan W. Buettgen MD; Ruben Gomez MD; Starr County Memorial Hospital,</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FF99CC" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3020</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Mario M. Jiminez MD; and Family Health Center of Rio Grande City, PA</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3021</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>000</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>51 yr old male fell from roof. treated in er & released. later diag. with fracture at c1. failure to diagnose</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3021</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LD</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>51 yr old male fell from roof. treated in er & released. later diag. with fracture at c1. failure to diagnose</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3022</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>000</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>46 yr old female underwent back surgery, complications during surgery, followed by transfer & extended hosp st</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3022</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LD</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>46 yr old female underwent back surgery, complications during surgery, followed by transfer & extended hosp st</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3022</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Linda S. Gillespie Eakins and Amber Dawn Gillespie vs. Dallas Speciality Hospital Limited Partnership d/b/a Dallas</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3022</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Speciality Hospital, Dallas Spine Group, P.A., David K. Selby, M.D., Robert James Henderson, M.D.,</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3022</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Robert James Henderson, M.D.,P.A., Robert Paul Fischer, M.D., Ben J. Tittle, M.D., and Ben J. Tittle, M.D., P.A.</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3023</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>000</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>76 yr old female tx in er w/foreign object in throat. underwent scope procedure. claims lacerated esophagus</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3023</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LD</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>76 yr old female tx in er w/foreign object in throat. underwent scope procedure. claims lacerated esophagus</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3023</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Carolyn Tillery, Individually and as Executrix of the Estate of Mary Lou Riba, Deceased vs. Dr. Raleigh Smith and Hill County Memorial Hospital</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3024</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>000</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>48 yo female tx in er and rushed to surgery. dx with a ruptured liver and transferred by air ambulance</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3024</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LD</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Claim Notes</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>48 yo female tx in er and rushed to surgery. dx with a ruptured liver and transferred by air ambulance</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3024</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Christina De Luna vs. Anand K. Mittal MD; Antonio Gallegos MD; Antonio Gallegos MD, PA Inc; Sebastian Padron,</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3024</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td bgcolor="#FFFFFF" align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>1993-11-30 00:00:00</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>LIT</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>Style of Case</nobr></font></td>
<td bgcolor="#FFFFFF" valign="bottom"><font face="Tahoma" size="2"><nobr>CONVERT</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>MD; and Maverick County Hospital District, d/b/a Maverick County Hospital (now knows as Fort Duncan Medical Center)</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
</table>
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,214,897
Messages
6,122,141
Members
449,066
Latest member
Andyg666

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top