Formula help...to insert rows

[Nhunter]

I am hoping to be able to insert a number of rows via formula. I am having issues coming up with anything on my own. I am hoping to duplicate(and insert) a specific row (x) number of times based on a number returned from a previous formula.

Any help would be greatly appriciated.

Best regards,
Nhunter

 

[Nhunter]

Column B should contain the cocantenation and as you can see the information from F preceed that from D. Does that make sense?

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 35px"><COL style="WIDTH: 34px"><COL style="WIDTH: 251px"><COL style="WIDTH: 25px"><COL style="WIDTH: 251px"><COL style="WIDTH: 22px"><COL style="WIDTH: 251px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">A</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">B</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">C</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">D</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">E</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">F</TD></TR><TR style="HEIGHT: 32px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">1</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">Item Name/Number</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">Name</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">Store Description</TD></TR><TR style="HEIGHT: 32px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">2</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL19040: Proform 785 Treadmill:224021</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PROFORM 785 TREADMILL:224021 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL19040 : PFTL19041</TD></TR><TR style="HEIGHT: 32px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL19041: Proform 785 Treadmill:224021</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; TEXT-ALIGN: right">1</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PROFORM 785 TREADMILL:224021 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL19040 : PFTL19041</TD></TR><TR style="HEIGHT: 47px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL20860: PROFORM 785 XT TREADMILL:186689 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; TEXT-ALIGN: right">4</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PROFORM 785 XT TREADMILL:186689 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</TD></TR><TR style="HEIGHT: 47px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL20861: PROFORM 785 XT TREADMILL:186689 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; TEXT-ALIGN: right">4</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PROFORM 785 XT TREADMILL:186689 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</TD></TR><TR style="HEIGHT: 47px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL20862: PROFORM 785 XT TREADMILL:186689 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; TEXT-ALIGN: right">4</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PROFORM 785 XT TREADMILL:186689 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</TD></TR><TR style="HEIGHT: 47px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL20863: PROFORM 785 XT TREADMILL:186689 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; TEXT-ALIGN: right">4</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PROFORM 785 XT TREADMILL:186689 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</TD></TR><TR style="HEIGHT: 47px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 8pt; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL20864: PROFORM 785 XT TREADMILL:186689 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana; TEXT-ALIGN: right">4</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PROFORM 785 XT TREADMILL:186689 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[VoG]

Sorry but no.

What should column F look like after "eliminating one item and the subsequent colon from column F in each new row" ?

 

[Nhunter]

I apologize. There is no requirement that the information in Column F change as long as Column B is generated as per the last display. I (perhaps mistakenly and most likely the case) was thinking that F would have to be changed in order to achieve the results displayed in column B.

 

[VoG]

Before running the macro

<b>Sheet5 (3)</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:296px;" /><col style="width:43px;" /><col style="width:372px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td >Name</td><td > </td><td >Store Description</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">1</td><td >PROFORM 785 TREADMILL:224021</td><td > </td><td >PFTL19040 : PFTL19041</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">4</td><td >PROFORM 785 XT TREADMILL:186689</td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">1</td><td >PROFORM CROSSWALK CSI TREADMILL:186689</td><td > </td><td >PFTL21460 : PFTL21462</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">2</td><td >PROFORM 345 TREADMILL:224019</td><td > </td><td >PFTL311040 : PFTL311041 : PFTL311042</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">1</td><td >PROFORM 330i TREADMILL:224019</td><td > </td><td >PFTL313040 : PFTL313041</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">2</td><td >PROFORM 495 Pi TREADMILL:227178</td><td > </td><td >PFTL331050 : PFTL331051 : PFTL331052</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">3</td><td >PROFORM 595 Pi TREADMILL:227178</td><td > </td><td >PFTL431050 : PFTL431051 : PFTL431052 : PFTL431053</td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4


After

<b>Sheet5 (2)</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:367px;" /><col style="width:43px;" /><col style="width:372px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td >Name</td><td > </td><td >Store Description</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">1</td><td >PROFORM 785 TREADMILL:224021 PFTL19040 </td><td > </td><td >PFTL19040 : PFTL19041</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">1</td><td >PROFORM 785 TREADMILL:224021 PFTL19041</td><td > </td><td >PFTL19040 : PFTL19041</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">4</td><td >PROFORM 785 XT TREADMILL:186689 PFTL20860 </td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">4</td><td >PROFORM 785 XT TREADMILL:186689 PFTL20861 </td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">4</td><td >PROFORM 785 XT TREADMILL:186689 PFTL20862 </td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">4</td><td >PROFORM 785 XT TREADMILL:186689 PFTL20863 </td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">4</td><td >PROFORM 785 XT TREADMILL:186689 PFTL20864</td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">1</td><td >PROFORM CROSSWALK CSI TREADMILL:186689 PFTL21460 </td><td > </td><td >PFTL21460 : PFTL21462</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:right; ">1</td><td >PROFORM CROSSWALK CSI TREADMILL:186689 PFTL21462</td><td > </td><td >PFTL21460 : PFTL21462</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:right; ">2</td><td >PROFORM 345 TREADMILL:224019 PFTL311040 </td><td > </td><td >PFTL311040 : PFTL311041 : PFTL311042</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="text-align:right; ">2</td><td >PROFORM 345 TREADMILL:224019 PFTL311041 </td><td > </td><td >PFTL311040 : PFTL311041 : PFTL311042</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="text-align:right; ">2</td><td >PROFORM 345 TREADMILL:224019 PFTL311042</td><td > </td><td >PFTL311040 : PFTL311041 : PFTL311042</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="text-align:right; ">1</td><td >PROFORM 330i TREADMILL:224019 PFTL313040 </td><td > </td><td >PFTL313040 : PFTL313041</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="text-align:right; ">1</td><td >PROFORM 330i TREADMILL:224019 PFTL313041</td><td > </td><td >PFTL313040 : PFTL313041</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="text-align:right; ">2</td><td >PROFORM 495 Pi TREADMILL:227178 PFTL331050 </td><td > </td><td >PFTL331050 : PFTL331051 : PFTL331052</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="text-align:right; ">2</td><td >PROFORM 495 Pi TREADMILL:227178 PFTL331051 </td><td > </td><td >PFTL331050 : PFTL331051 : PFTL331052</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="text-align:right; ">2</td><td >PROFORM 495 Pi TREADMILL:227178 PFTL331052</td><td > </td><td >PFTL331050 : PFTL331051 : PFTL331052</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="text-align:right; ">3</td><td >PROFORM 595 Pi TREADMILL:227178 PFTL431050 </td><td > </td><td >PFTL431050 : PFTL431051 : PFTL431052 : PFTL431053</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="text-align:right; ">3</td><td >PROFORM 595 Pi TREADMILL:227178 PFTL431051 </td><td > </td><td >PFTL431050 : PFTL431051 : PFTL431052 : PFTL431053</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="text-align:right; ">3</td><td >PROFORM 595 Pi TREADMILL:227178 PFTL431052 </td><td > </td><td >PFTL431050 : PFTL431051 : PFTL431052 : PFTL431053</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="text-align:right; ">3</td><td >PROFORM 595 Pi TREADMILL:227178 PFTL431053</td><td > </td><td >PFTL431050 : PFTL431051 : PFTL431052 : PFTL431053</td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4


Is this not what you wanted?

 

[Nhunter]

With the information from Column F (with a colon) in front of that in column D. So the first instance of Column D would read PFTL19040: PROFORM 785 TREADMILL:224021 instead of PROFORM 785 TREADMILL:224021 PFTL19040....and so on.

 

[VoG]

Try

Sub InsRows()
Dim LR As Long, i As Long, j As Integer, X
LR = Range("C" & Rows.Count).End(xlUp).Row
For i = LR To 2 Step -1
    With Range("C" & i)
        .Offset(1).Resize(.Value).EntireRow.Insert
        .EntireRow.Copy Destination:=.Offset(1, -2).Resize(.Value)
        X = Split(.Offset(, 3), ":")
        .Offset(, 1).Value = Trim(X(0)) & ": " & .Offset(, 1).Value
        For j = 1 To UBound(X)
            .Offset(j, 1).Value = Trim(X(j)) & ": " & .Offset(j, 1).Value
        Next j
    End With
Next i
Columns("D").AutoFit
End Sub

 

[Nhunter]

Getting a visual basic "400" Error

 

[VoG]

Click Debug - which line of code is highlighted?

 

[Nhunter]

It seems to be putting all the information from F in each instance rather that taking the incremental approach as you had working with the information at the end.


CustomItemSearch4Results253(1)

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 64px"><COL style="WIDTH: 540px"><COL style="WIDTH: 48px"><COL style="WIDTH: 400px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1351</TD><TD style="TEXT-ALIGN: right">3</TD><TD>NTL078060: NTL078062: NTL078062: NTL078065: NTL078065 : NordicTrack C2255 : Drv Mtr</TD><TD> </TD><TD>NTL078060: NTL078061: NTL078062: NTL078065</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1352</TD><TD style="TEXT-ALIGN: right">3</TD><TD>NTL078061: NTL078062: NTL078062: NTL078065: NTL078065 : NordicTrack C2255 : Drv Mtr</TD><TD> </TD><TD>NTL078060: NTL078061: NTL078062: NTL078065</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1353</TD><TD style="TEXT-ALIGN: right">3</TD><TD>NTL078062: NTL078062: NTL078062: NTL078065: NTL078065 : NordicTrack C2255 : Drv Mtr</TD><TD> </TD><TD>NTL078060: NTL078061: NTL078062: NTL078065</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1354</TD><TD style="TEXT-ALIGN: right">3</TD><TD>NTL078065: NTL078062: NTL078062: NTL078065: NTL078065 : NordicTrack C2255 : Drv Mtr</TD><TD> </TD><TD>NTL078060: NTL078061: NTL078062: NTL078065</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1355</TD><TD style="TEXT-ALIGN: right">3</TD><TD>NTL078060: NTL078065: NTL078062: NTL078065: NTL078065 : NordicTrack C2255 : Drv Mtr</TD><TD> </TD><TD>NTL078060: NTL078061: NTL078062: NTL078065</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1356</TD><TD style="TEXT-ALIGN: right">3</TD><TD>NTL078061: NTL078065: NTL078062: NTL078065: NTL078065 : NordicTrack C2255 : Drv Mtr</TD><TD> </TD><TD>NTL078060: NTL078061: NTL078062: NTL078065</TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>C1351</TD><TD>=LEN(F1351)-LEN(SUBSTITUTE(F1351,":",""))</TD></TR><TR><TD>C1352</TD><TD>=LEN(F1352)-LEN(SUBSTITUTE(F1352,":",""))</TD></TR><TR><TD>C1353</TD><TD>=LEN(F1353)-LEN(SUBSTITUTE(F1353,":",""))</TD></TR><TR><TD>C1354</TD><TD>=LEN(F1354)-LEN(SUBSTITUTE(F1354,":",""))</TD></TR><TR><TD>C1355</TD><TD>=LEN(F1355)-LEN(SUBSTITUTE(F1355,":",""))</TD></TR><TR><TD>C1356</TD><TD>=LEN(F1356)-LEN(SUBSTITUTE(F1356,":",""))</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[VoG]

That's not what I'm getting:

<b>Sheet5 (3)</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:368px;" /><col style="width:43px;" /><col style="width:372px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >C</td><td >D</td><td >E</td><td >F</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td > </td><td >Name</td><td > </td><td >Store Description</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">1</td><td >PFTL19040: PROFORM 785 TREADMILL:224021</td><td > </td><td >PFTL19040 : PFTL19041</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">1</td><td >PFTL19041: PROFORM 785 TREADMILL:224021</td><td > </td><td >PFTL19040 : PFTL19041</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">4</td><td >PFTL20860: PROFORM 785 XT TREADMILL:186689</td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">4</td><td >PFTL20861: PROFORM 785 XT TREADMILL:186689</td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">4</td><td >PFTL20862: PROFORM 785 XT TREADMILL:186689</td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">4</td><td >PFTL20863: PROFORM 785 XT TREADMILL:186689</td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">4</td><td >PFTL20864: PROFORM 785 XT TREADMILL:186689</td><td > </td><td >PFTL20860 : PFTL20861 : PFTL20862 : PFTL20863 : PFTL20864</td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4