2聽WCBS New York (CBS)
3聽WPXN New York (ION)
4聽WNBC New York (NBC)
5聽WNYW New York (FOX)
6聽Univision
7聽WABC New York (ABC)
8聽New York 1 News
9聽My9 New York (MNT-WWOR)
10聽WLNY Riverhead (IND)
11聽WPIX (11) New York
12聽News 12 Brooklyn
13聽WNET New York (PBS)
14聽MSG Varsity
15聽QVC
16聽WNJU Linden (Telemundo)
17聽TeleFutura
18聽HSN
19聽WRNN Kingston (IND)
20聽WMBC Newton (IND)
21聽WLIW Plainview (PBS)
22聽NYC Life
23聽MSNBC
24聽CNBC
25聽CNN
26聽FOX News Channel
27聽Discovery Channel
28聽TLC
30聽The NET
31聽Disney Channel
32聽Cartoon Network
33聽Nickelodeon
34聽TV Land
35聽ESPN2
36聽ESPN
37聽TNT
38聽USA Network
39聽TBS
40聽FX
41聽Turner Classic Movies
42聽WE tv
43聽AMC
44聽Bravo
45聽Lifetime
46聽A%26amp;E
47聽History
48聽Syfy
49聽ABC Family
50聽Comedy Central
51聽E!
52聽VH1
53聽MTV
54聽BET
55聽MTV2
56聽Spike TV
57聽Animal Planet
58聽truTV
59聽Religious Programming
60聽SportsNet New York
61聽News 12 Traffic %26amp; Weather
62聽The Weather Channel
63聽Galavisi贸n
64聽SoapNet
65聽C-SPAN
66聽C-SPAN2
67聽Brooklyn Community Access TV
68聽Brooklyn Community Access TV
69聽Brooklyn Community Access TV
70聽Brooklyn Community Access TV
71聽OTB on NYC TV
72聽NYC Drive
73聽NYC World
74聽NYC Government
75聽CUNY on NYC TV
76聽GSN
77聽CNN Headline News
78聽fuse
80聽Cablevision Channel Guide
81聽Oxygen
82聽HBO
83聽IFC
84聽Showtime
85聽Cinemax
86聽The Movie Channel
87聽MSG
88聽MSG Plus
89聽YES Network
90聽Showtime Too
91聽Flix
92聽Pay Per View
93聽Pay Per View
94聽Playboy TV (Adult)
95聽Spice Xcess (Adult)
96聽Travel Channel
97聽Food Network
98聽HGTV
99聽Speed Channel
100聽iO Digital Channel Guide
101聽BBC America
102聽C-SPAN3
103聽EuroNews
104聽BBC World News
105聽Bloomberg TV
106聽FOX Business Network
108聽Live Well
109聽NBC NY Non-Stop
110聽Universal Sports
114聽Antenna TV
115聽Estrella TV
116聽NYS Legislative TV
118聽Leased Access
120聽The Hub
121聽Disney XD
122聽Nicktoons Network
123聽Nick Jr.
124聽TeenNick
125聽Boomerang
131聽Kids Thirteen
132聽WLIW World
133聽WLIW Create
134聽WTBY (54)
135聽EWTN
136聽Daystar
137聽Telecare
140聽ESPN Classic
141聽ESPNews
142聽FOX Soccer Channel
143聽CBS Sports Network
144聽ESPNU
145聽The Golf Channel
146聽VERSUS
148聽NBA TV
149聽MLB Network
158聽National Geographic Wild
160聽Bio
161聽H2In microsoft excel: alpha by name, keeping #'s?
Will this do:
46 A%26amp;E
49 ABC Family
43 AMC
57 Animal Planet
114 Antenna TV
101 BBC America
104 BBC World News
54 BET
160 Bio
105 Bloomberg TV
125 Boomerang
44 Bravo
67 Brooklyn Community Access TV
68 Brooklyn Community Access TV
69 Brooklyn Community Access TV
70 Brooklyn Community Access TV
80 Cablevision Channel Guide
32 Cartoon Network
143 CBS Sports Network
85 Cinemax
24 CNBC
25 CNN
77 CNN Headline News
50 Comedy Central
65 C-SPAN
66 C-SPAN2
102 C-SPAN3
75 CUNY on NYC TV
136 Daystar
27 Discovery Channel
31 Disney Channel
121 Disney XD
51 E!
36 ESPN
140 ESPN Classic
35 ESPN2
141 ESPNews
144 ESPNU
115 Estrella TV
103 EuroNews
135 EWTN
91 Flix
97 Food Network
106 FOX Business Network
26 FOX News Channel
142 FOX Soccer Channel
78 fuse
40 FX
63 Galavisi贸n
76 GSN
161 H2
82 HBO
98 HGTV
47 History
18 HSN
83 IFC
100 iO Digital Channel Guide
131 Kids Thirteen
118 Leased Access
45 Lifetime
108 Live Well
149 MLB Network
87 MSG
88 MSG Plus
14 MSG Varsity
23 MSNBC
53 MTV
55 MTV2
9 My9 New York (MNT-WWOR)
158 National Geographic Wild
148 NBA TV
109 NBC NY Non-Stop
8 New York 1 News
12 News 12 Brooklyn
61 News 12 Traffic %26amp; Weather
123 Nick Jr.
33 Nickelodeon
122 Nicktoons Network
72 NYC Drive
74 NYC Government
22 NYC Life
73 NYC World
116 NYS Legislative TV
71 OTB on NYC TV
81 Oxygen
92 Pay Per View
93 Pay Per View
94 Playboy TV (Adult)
15 QVC
59 Religious Programming
84 Showtime
90 Showtime Too
64 SoapNet
99 Speed Channel
95 Spice Xcess (Adult)
56 Spike TV
60 SportsNet New York
48 Syfy
39 TBS
124 TeenNick
137 Telecare
17 TeleFutura
145 The Golf Channel
120 The Hub
86 The Movie Channel
30 The NET
62 The Weather Channel
28 TLC
37 TNT
96 Travel Channel
58 truTV
41 Turner Classic Movies
34 TV Land
110 Universal Sports
6 Univision
38 USA Network
146 VERSUS
52 VH1
7 WABC New York (ABC)
2 WCBS New York (CBS)
42 WE tv
133 WLIW Create
21 WLIW Plainview (PBS)
132 WLIW World
10 WLNY Riverhead (IND)
20 WMBC Newton (IND)
4 WNBC New York (NBC)
13 WNET New York (PBS)
16 WNJU Linden (Telemundo)
5 WNYW New York (FOX)
11 WPIX (11) New York
3 WPXN New York (ION)
19 WRNN Kingston (IND)
134 WTBY (54)
89 YES NetworkIn microsoft excel: alpha by name, keeping #'s?
these are all the channels I need alpha by channel w/ #.
http://www.optimum.com/lineup.鈥?/a>
"1300 channel's of s*** on the tv to choose from"
Report Abuse
In microsoft excel: alpha by name, keeping #'s?You can use the following event handler to sort as you wish. This assumes the data is in column A and column B is available for temp use.
Copy the following event handler to the clipboard:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim i, LastRow
LastRow = Application.Cells. SpecialCells(xlCellTypeLastCell).Row
Application.ScreenUpdating = False
For i = 1 To LastRow
For j = 1 To Len(Cells(i, "A"))
If Not IsNumeric(Mid(Cells(i, "A"), j, 1)) Then
Cells(i, "B").Value = Right(Cells(i, "A"), Len(Cells(i, "A")) - j)
GoTo here
End If
Next
here:
Next
Columns("A:B").Select
Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Columns("B:B").ClearContents
Range("A1").Select
End Sub
Select the worksheet containing the data and right click the sheet tab.
Select 'View Code'.
Paste the event handler into the editing area to the right.
Close the VBE and return to the worksheet.
Double click any cell to sort the data. If additional data is added, just double click any cell again.
No comments:
Post a Comment