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

andyfox1979 · Jan 11, 2015

So i have a dataset from a vendor that is many different models of printer ink. Here's an example:

Brand

Series

Models

price

OEM#

TYPE

COLOR

Brother

Fax

1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN

2.99

LC41BK

Inkjet

Black

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!

andyfox1979 · Jan 11, 2015

Here's a bigger chunk of data to see what i'm dealing with:

Brand	Model Numbers	OEM SKU	SKU	CARTRIDGE TYPE	COLOR	Price
Brother	Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN	LC41BK	CLC41BK	Compatible	Black	0.765
Brother	Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN	LC41C	CLC41C	Compatible	Cyan	0.7225
Brother	Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN	LC41M	CLC41M	Compatible	Magenta	0.7225
Brother	Fax 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN	LC41Y	CLC41Y	Compatible	Yellow	0.7225
Brother	MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN	LC51BK	CLC51BK	Compatible	Black	0.765
Brother	MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN	LC51C	CLC51C	Compatible	Cyan	0.7225
Brother	MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN	LC51M	CLC51M	Compatible	Magenta	0.7225
Brother	MFC 240, 440CN, 665CW, 845CW, 5460CN, 5860CN	LC51Y	CLC51Y	Compatible	Yellow	0.7225
Brother	DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW	LC61BK	CLC61BK	Compatible	Black	0.765
Brother	DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW	LC61C	CLC61C	Compatible	Cyan	0.7225
Brother	DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW	LC61M	CLC61M	Compatible	Magenta	0.7225
Brother	DCP 165C; MFC 290C, 490CW, 5490CN, 5890CN, 6490CW, 790CW	LC61Y	CLC61Y	Compatible	Yellow	0.7225
Brother	MFC 5890CN, 6490CW High Yield	LC65BK	CLC65BK	Compatible	Black	0.8075

Rick Rothstein · Jan 11, 2015

See the code I posted in my mini-blog article here...

Redistribute a Delimited Column Of Data into Separate Rows (Keeping Other Data As Is)

andyfox1979 · Jan 11, 2015

Rick, you're a genius as usual. Can I send a paypal donation to your blog?

Rick Rothstein · Jan 11, 2015

andyfox1979 said:
Rick... Can I send a paypal donation to your blog?

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).

apo · Jan 11, 2015

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

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

andyfox1979

New Member

Excel Facts

andyfox1979

New Member

Rick Rothstein

MrExcel MVP

andyfox1979

New Member

Rick Rothstein

MrExcel MVP

apo

Well-known Member

Similar threads

Forum statistics

Share this page

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

andyfox1979

New Member

Excel Facts

andyfox1979

New Member

Rick Rothstein

MrExcel MVP

andyfox1979

New Member

Rick Rothstein

MrExcel MVP

apo

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock