Extract Multiple Text Values from 1 Continuous String

[kaneda0149]

Hi All,

I've had a hard time looking for an string extraction that does multiple things;

1. Extract just the number like value before the $ or @ symbol
2. Extract just the date like value
3. Extract value after the word "call" but before the $ or @ symbol
4. Extract value after the word "put" but before the $ or @ symbol

My sample data looks like this:
<TABLE style="WIDTH: 250pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=333 border=0 x:str><COLGROUP><COL style="WIDTH: 250pt; mso-width-source: userset; mso-width-alt: 12178" width=333><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: #cccccc 0.5pt solid; BORDER-TOP: #cccccc 0.5pt solid; BORDER-LEFT: #cccccc 0.5pt solid; WIDTH: 250pt; BORDER-BOTTOM: #cccccc 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=333 height=17>Call Chev. $60 Expiring 12/17/05</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: #cccccc 0.5pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 0.5pt solid; BORDER-BOTTOM: #cccccc 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>Call Chev. $60.0 Expiring 12/17/05</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: #cccccc 0.5pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 0.5pt solid; BORDER-BOTTOM: #cccccc 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>Call Friedman Billings $30 Expiring 9/18/04</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: #cccccc 0.5pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 0.5pt solid; BORDER-BOTTOM: #cccccc 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>Call Index $410.04 Expiring 08/22/09</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: #cccccc 0.5pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 0.5pt solid; BORDER-BOTTOM: #cccccc 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>Put SP 3500 @80 Exp 12/20/97</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: #cccccc 0.5pt solid; BORDER-TOP: #cccccc; BORDER-LEFT: #cccccc 0.5pt solid; BORDER-BOTTOM: #cccccc 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>Put SP 3500 @67.5 Exp 12/18/99</TD></TR></TBODY></TABLE>

Desired Outcome in the following columns:
<TABLE style="WIDTH: 233pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=310 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><TBODY><TR style="HEIGHT: 10.5pt" height=14><TD class=xl22 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 10.5pt; BACKGROUND-COLOR: silver" width=64 height=14>Column B</TD><TD class=xl22 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696; WIDTH: 48pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: silver" width=64>Column C</TD><TD class=xl22 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696; WIDTH: 82pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: silver" width=109>Column D</TD><TD class=xl22 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696; WIDTH: 55pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: silver" width=73>Column E</TD></TR><TR style="HEIGHT: 10.5pt" height=14><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 10.5pt; BACKGROUND-COLOR: transparent" height=14 x:num>60</TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">Chev.</TD><TD class=xl24 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">12/17/05</TD></TR><TR style="HEIGHT: 10.5pt" height=14><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 10.5pt; BACKGROUND-COLOR: transparent" height=14 x:num>60</TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">Chev.</TD><TD class=xl24 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">12/17/05</TD></TR><TR style="HEIGHT: 10.5pt" height=14><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 10.5pt; BACKGROUND-COLOR: transparent" height=14 x:num>30</TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">Friedman Billings</TD><TD class=xl24 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">9/18/04</TD></TR><TR style="HEIGHT: 10.5pt" height=14><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 10.5pt; BACKGROUND-COLOR: transparent" height=14 x:num>410</TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>4</TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">Index</TD><TD class=xl24 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">08/22/09</TD></TR><TR style="HEIGHT: 10.5pt" height=14><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 10.5pt; BACKGROUND-COLOR: transparent" height=14 x:num>80</TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">SP 3500</TD><TD class=xl24 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">12/20/97</TD></TR><TR style="HEIGHT: 10.5pt" height=14><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 10.5pt; BACKGROUND-COLOR: transparent" height=14 x:num>67</TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>5</TD><TD class=xl23 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">SP 3500</TD><TD class=xl24 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696; BORDER-LEFT: #969696; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent">12/18/99</TD></TR></TBODY></TABLE>

Not sure if this is even possible but could not find what I need to split the data up. Thanks in advance for any help!

 

[gsbelbin]

All the text appears to be space delimited, with one or two exceptions. If this is just a one off then I would suggest selecting it all and then using the "Text to columns" wizard and then drag the columns as you wish. There are a few that would need to be tweaked manually but hopefully not too many.

 

[kaneda0149]

Was just trying to avoid that because I have over 25,000 records. Thanks gsbelbin for the quick response!

 

[gsbelbin]

Do you have to leave the @ as they are or could you do a global conversion to $ before you start parsing the text? It would make things much easier.

 

[kaneda0149]

It varies, the data is all user input. So it could be anything but @ is equivalent to $ for the most part. I'm sure I can't get 99% accurate but 80% would be awesome.

 

[gsbelbin]

IF you can replace all @ with $ and you want to extract the number as one entry rather than split what's before and after the decimal point, then the formulas below should do the job. If not it gets a bit more complicated

My text string was in K10 and the formulas are below for each part.

=MID(K10,SEARCH("$",K10,1)+1,SEARCH(" ",K10,SEARCH("$",K10,1))-SEARCH("$",K10,1)-1)

=MID(K10,SEARCH(" ",K10,1)+1,SEARCH("$",K10,SEARCH(" ",K10,1))-SEARCH(" ",K10,1)-1)

=RIGHT(K10,LEN(K10)-SEARCH(" ",K10,SEARCH("/",K10,1)-4))

Like I say this extracts the number into one cell rather than splitting it. I can't see why you would want to split it as you have since the you have $0.04 shown as 4 in one line but $0.50 shown as 5 in another.

 

[pgc01]

Hi

This is a udf based in your examples. The function ParseString() extracts the 4 elements you need in the order they appear in the string and you compose the output as you wish. In your example

In B1: =ParseString($A1,2)
In C1: =ParseString($A1,3)
In D1: =ParseString($A1,1)
In E1: =ParseString($A1,4)

Copy down

Function ParseString(s As String, lInd As Long)
 
With CreateObject("VBScript.RegExp")
    .Pattern = "^(?:Call|Put)\s+(.*)?\s+[$@](\d+)(?:.(\d+))?\s+Exp.*?\s+(\d+/\d+/\d+)$"
    If .test(s) Then ParseString = .Execute(s)(0).submatches(lInd - 1)
    If (lInd = 3) And IsEmpty(ParseString) Then
        ParseString = vbNullString
    ElseIf lInd = 2 Or lInd = 3 Then
        ParseString = Val(ParseString)
    ElseIf lInd = 4 Then
        ParseString = CDate(ParseString)
    End If
End With
End Function

<table border="1" cellpadding="1" style="background:#FFF; border-collapse:collapse;border-width:2px;border-color:#CCCCCC;font-family:Arial,Arial; font-size:10pt" ><tr><th style="border-width:1px;border-color:#888888;background:#9CF " > </th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >A</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >B</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >C</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >D</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" >E</th><th style="border-width:1px;border-color:#888888;background:#9CF; text-align:center" width=30 >F</th></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>1</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Call Chev. $60 Expiring 12/17/05</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">60</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Chev.</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">12/17/05</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>2</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Call Chev. $60.0 Expiring 12/17/05</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">60</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">0</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Chev.</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">12/17/05</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>3</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Call Friedman Billings $30 Expiring 9/18/04</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">30</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Friedman Billings</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">09/18/04</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>4</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Call Index $410.04 Expiring 08/22/09</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">410</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">4</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Index</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">08/22/09</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>5</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Put SP 3500 @80 Exp 12/20/97</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">80</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">SP 3500</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">12/20/97</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>6</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">Put SP 3500 @67.5 Exp 12/18/99</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">67</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">5</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:left;border-width: 1px;border-color:#888888; ">SP 3500</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; ">12/18/99</td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;background:#9CF; text-align:center; " ><b>7</b></td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td><td style="border-width:1px;border-color:#000000; padding-left:0.5em; padding-top:0.4em; padding-right:0.5em; padding-bottom:0.25em;text-align:right;border-width: 1px;border-color:#888888; "> </td></tr><tr><td colspan=7 style="background:#9CF; padding-left:1em" > [Book1]Sheet2</td></tr></table>

 

[kaneda0149]

Thank you both so MUCH !!!

gsbelbin - that worked great

pgc01 - I added the function to my worksheet in the code view but when I added the "=ParseString" in the cell, I got the #NAME? error. I then added to this workbook code and still no luck. How do I get this function to launch? I'd like to try it out.

 

[pgc01]

A udf should not be inserted into an object module.

Insert a standard module (Insert->Module) and paste the code there.

 

[kaneda0149]

Duhhhhh... I'm such an idiot. That worked perfectly pgc01. Have a great weekend