Is there a way to paste by delimiter? (commas in this case)

A

andyfox1979

New Member
Joined
Dec 5, 2012
Messages
32
So i have a dataset from a vendor that is many different models of printer ink. Here's an example:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Brand[/TD]
[TD]Series[/TD]
[TD]Models[/TD]
[TD]price[/TD]
[TD]OEM#[/TD]
[TD]TYPE[/TD]
[TD]COLOR[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]Fax[/TD]
[TD][TABLE="width: 378"]
<tbody>[TR]
[TD]1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2.99[/TD]
[TD][TABLE="width: 119"]
<tbody>[TR]
[TD]LC41BK[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Inkjet[/TD]
[TD]Black[/TD]
[/TR]
</tbody>[/TABLE]


Id like to paste the Models column down, separated by commas, so that i can drag down the other columns down since that data is shared with each comma separated item, and have one model per line.

(Ideally, i wish there was a VBA that would automatically fill those in after moving the models down to new rows).

I know some busch league ways of doing this (text to columns then C+V transpose) but it just takes too long since i have hundreds of these.

Is there any way to simply copy and paste these and seperate them with the comma as the delimiter? I can TRIM etc later to format it.

Thanks in advance, this project is ruining my saturday night!
 
Sort by date Sort by votes
Here's a bigger chunk of data to see what i'm dealing with:

[TABLE="width: 927"]
<colgroup><col><col><col span="5"></colgroup><tbody>[TR]
[TD]Brand[/TD]
[TD]Model Numbers[/TD]
[TD]OEM SKU[/TD]
[TD]SKU[/TD]
[TD]CARTRIDGE TYPE[/TD]
[TD]COLOR[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN[/TD]
[TD]LC41BK[/TD]
[TD]CLC41BK[/TD]
[TD]Compatible[/TD]
[TD]Black[/TD]
[TD="align: right"]0.765[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN[/TD]
[TD]LC41C[/TD]
[TD]CLC41C[/TD]
[TD]Compatible[/TD]
[TD]Cyan[/TD]
[TD="align: right"]0.7225[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN[/TD]
[TD]LC41M[/TD]
[TD]CLC41M[/TD]
[TD]Compatible[/TD]
[TD]Magenta[/TD]
[TD="align: right"]0.7225[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN[/TD]
[TD]LC41Y[/TD]
[TD]CLC41Y[/TD]
[TD]Compatible[/TD]
[TD]Yellow[/TD]
[TD="align: right"]0.7225[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN[/TD]
[TD]LC51BK[/TD]
[TD]CLC51BK[/TD]
[TD]Compatible[/TD]
[TD]Black[/TD]
[TD="align: right"]0.765[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN[/TD]
[TD]LC51C[/TD]
[TD]CLC51C[/TD]
[TD]Compatible[/TD]
[TD]Cyan[/TD]
[TD="align: right"]0.7225[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN[/TD]
[TD]LC51M[/TD]
[TD]CLC51M[/TD]
[TD]Compatible[/TD]
[TD]Magenta[/TD]
[TD="align: right"]0.7225[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN[/TD]
[TD]LC51Y[/TD]
[TD]CLC51Y[/TD]
[TD]Compatible[/TD]
[TD]Yellow[/TD]
[TD="align: right"]0.7225[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW[/TD]
[TD]LC61BK[/TD]
[TD]CLC61BK[/TD]
[TD]Compatible[/TD]
[TD]Black[/TD]
[TD="align: right"]0.765[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW[/TD]
[TD]LC61C[/TD]
[TD]CLC61C[/TD]
[TD]Compatible[/TD]
[TD]Cyan[/TD]
[TD="align: right"]0.7225[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW[/TD]
[TD]LC61M[/TD]
[TD]CLC61M[/TD]
[TD]Compatible[/TD]
[TD]Magenta[/TD]
[TD="align: right"]0.7225[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW[/TD]
[TD]LC61Y[/TD]
[TD]CLC61Y[/TD]
[TD]Compatible[/TD]
[TD]Yellow[/TD]
[TD="align: right"]0.7225[/TD]
[/TR]
[TR]
[TD]Brother[/TD]
[TD]MFC 5890CN, 6490CW High Yield[/TD]
[TD]LC65BK[/TD]
[TD]CLC65BK[/TD]
[TD]Compatible[/TD]
[TD]Black[/TD]
[TD="align: right"]0.8075[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
andyfox1979 said:
Rick... Can I send a paypal donation to your blog?
Click to expand...
No... help on this forum is free (besides, if you tried, the payment would end up going to the forum owners who have granted me a sub-forum on their site which I use as a blog).
 
Upvote 0
Hi..

Here's another possible way..

Result shown on sheet2..

Code: 
Private Sub CommandButton1_Click()
 Dim x, y, cnt As Long, k As Long, s As Long, j As Long, i As Long, ii As Long
    With Range("A1").CurrentRegion
        x = .Offset(1).Resize(.Rows.Count - 1).Value
        cnt = 1: k = 1: s = 1
        ReDim y(1 To UBound(Split(Replace(Join(Application.Transpose(.Columns(2).Offset(1).Resize(.Rows.Count - 1).Value), vbLf), vbLf, ","), ",")) + 1, 1 To 7)
        For i = 1 To UBound(y)
            For j = 0 To UBound(Split(x(cnt, 2), ","))
                For ii = 1 To UBound(x, 2)
                    If ii = 2 Then
                        y(k, ii) = Trim(Split(x(cnt, 2), ",")(j))
                    Else
                        y(k, ii) = Trim(x(cnt, ii))
                    End If
                Next ii
                If s = UBound(Split(x(cnt, 2), ",")) + 1 Then
                    k = k + 1: cnt = cnt + 1: Exit For
                Else
                    k = k + 1: s = s + 1
                End If
            Next j
            s = 1
            If k > UBound(y) Then
                With Sheets("Sheet2")
                    .Range("A2").Resize(UBound(y), 7).Value = y
                    .Columns.AutoFit
                    .Select
                End With
                Exit Sub
            End If
        Next i
    End With
End Sub

<b>Sheet1</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:54px;" /><col style="width:536px;" /><col style="width:63px;" /><col style="width:59px;" /><col style="width:109px;" /><col style="width:61px;" /><col style="width:49px;" /></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><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; " >1</td><td >Brand</td><td >Model Numbers</td><td >OEM SKU</td><td >SKU</td><td >CARTRIDGE TYPE</td><td >COLOR</td><td >Price</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Brother</td><td >Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Brother</td><td >Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Brother</td><td >Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Brother</td><td >Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >Brother</td><td >MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN</td><td >LC51BK</td><td >CLC51BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Brother</td><td >MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN</td><td >LC51C</td><td >CLC51C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >Brother</td><td >MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN</td><td >LC51M</td><td >CLC51M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >Brother</td><td >MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN</td><td >LC51Y</td><td >CLC51Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Brother</td><td >DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW</td><td >LC61BK</td><td >CLC61BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >Brother</td><td >DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW</td><td >LC61C</td><td >CLC61C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >Brother</td><td >DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW</td><td >LC61M</td><td >CLC61M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >Brother</td><td >DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW</td><td >LC61Y</td><td >CLC61Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td >Brother</td><td >MFC 5890CN, 6490CW High Yield</td><td >LC65BK</td><td >CLC65BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.8075</td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4


<b>Sheet2</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:54px;" /><col style="width:132px;" /><col style="width:63px;" /><col style="width:59px;" /><col style="width:109px;" /><col style="width:61px;" /><col style="width:49px;" /></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><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; " >1</td><td >Brand</td><td >Model Numbers</td><td >OEM SKU</td><td >SKU</td><td >CARTRIDGE TYPE</td><td >COLOR</td><td >Price</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Brother</td><td >Fax 1840C</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Brother</td><td >1940CN</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Brother</td><td >2440C</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Brother</td><td >MFC210C</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >Brother</td><td >420CN</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Brother</td><td >620CN</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >Brother</td><td >3240C</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >Brother</td><td >3340CN</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Brother</td><td >5440CN</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >Brother</td><td >5840CN</td><td >LC41BK</td><td >CLC41BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >Brother</td><td >Fax 1840C</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >Brother</td><td >1940CN</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td >Brother</td><td >2440C</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td >Brother</td><td >MFC210C</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td >Brother</td><td >420CN</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td >Brother</td><td >620CN</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td >Brother</td><td >3240C</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td >Brother</td><td >3340CN</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td >Brother</td><td >5440CN</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td >Brother</td><td >5840CN</td><td >LC41C</td><td >CLC41C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td >Brother</td><td >Fax 1840C</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td >Brother</td><td >1940CN</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td >Brother</td><td >2440C</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td >Brother</td><td >MFC210C</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td >Brother</td><td >420CN</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >27</td><td >Brother</td><td >620CN</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >28</td><td >Brother</td><td >3240C</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >29</td><td >Brother</td><td >3340CN</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >30</td><td >Brother</td><td >5440CN</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >31</td><td >Brother</td><td >5840CN</td><td >LC41M</td><td >CLC41M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >32</td><td >Brother</td><td >Fax 1840C</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >33</td><td >Brother</td><td >1940CN</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >34</td><td >Brother</td><td >2440C</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >35</td><td >Brother</td><td >MFC210C</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >36</td><td >Brother</td><td >420CN</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >37</td><td >Brother</td><td >620CN</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >38</td><td >Brother</td><td >3240C</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >39</td><td >Brother</td><td >3340CN</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >40</td><td >Brother</td><td >5440CN</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >41</td><td >Brother</td><td >5840CN</td><td >LC41Y</td><td >CLC41Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >42</td><td >Brother</td><td >MFC 240</td><td >LC51BK</td><td >CLC51BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >43</td><td >Brother</td><td >440CN</td><td >LC51BK</td><td >CLC51BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >44</td><td >Brother</td><td >665CW</td><td >LC51BK</td><td >CLC51BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >45</td><td >Brother</td><td >845CW</td><td >LC51BK</td><td >CLC51BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >46</td><td >Brother</td><td >5460CN</td><td >LC51BK</td><td >CLC51BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >47</td><td >Brother</td><td >5860CN</td><td >LC51BK</td><td >CLC51BK</td><td >Compatible</td><td >Black</td><td style="text-align:right; ">0.765</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >48</td><td >Brother</td><td >MFC 240</td><td >LC51C</td><td >CLC51C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >49</td><td >Brother</td><td >440CN</td><td >LC51C</td><td >CLC51C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >50</td><td >Brother</td><td >665CW</td><td >LC51C</td><td >CLC51C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >51</td><td >Brother</td><td >845CW</td><td >LC51C</td><td >CLC51C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >52</td><td >Brother</td><td >5460CN</td><td >LC51C</td><td >CLC51C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >53</td><td >Brother</td><td >5860CN</td><td >LC51C</td><td >CLC51C</td><td >Compatible</td><td >Cyan</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >54</td><td >Brother</td><td >MFC 240</td><td >LC51M</td><td >CLC51M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >55</td><td >Brother</td><td >440CN</td><td >LC51M</td><td >CLC51M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >56</td><td >Brother</td><td >665CW</td><td >LC51M</td><td >CLC51M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >57</td><td >Brother</td><td >845CW</td><td >LC51M</td><td >CLC51M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >58</td><td >Brother</td><td >5460CN</td><td >LC51M</td><td >CLC51M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >59</td><td >Brother</td><td >5860CN</td><td >LC51M</td><td >CLC51M</td><td >Compatible</td><td >Magenta</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >60</td><td >Brother</td><td >MFC 240</td><td >LC51Y</td><td >CLC51Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >61</td><td >Brother</td><td >440CN</td><td >LC51Y</td><td >CLC51Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >62</td><td >Brother</td><td >665CW</td><td >LC51Y</td><td >CLC51Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >63</td><td >Brother</td><td >845CW</td><td >LC51Y</td><td >CLC51Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >64</td><td >Brother</td><td >5460CN</td><td >LC51Y</td><td >CLC51Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >65</td><td >Brother</td><td >5860CN</td><td >LC51Y</td><td >CLC51Y</td><td >Compatible</td><td >Yellow</td><td style="text-align:right; ">0.7225</td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4
 
Upvote 0
You must log in or register to reply here.

Similar threads

scott_n_phnx
  • Question Question
Breaking Out Comma Delimited Column to Row
Replies
2
Views
608
scott_n_phnx
scott_n_phnx
D
  • Question Question
VBA to Convert Comma Delimited Cell into Rows With values in Other Columns
Replies
1
Views
1K
desairs
D

Share this page

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