Drag the formula C1 to the right and down ...
...duh. Sorry, it's been a busy morning and I haven't had enough coffee!
That's getting closer! I love that it's a formula-based solution too and I can scale it to multiple columns. It is, however, extracting a lot of extraneous information that doesn't match the XX000 / XX000X string. Here's some sample data along with the results from your formula:
[TABLE="width: 1123"]
<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]
Summary[/TD]
[TD]
String1[/TD]
[TD]
String2[/TD]
[TD]
String3[/TD]
[TD][/TD]
[TD][/TD]
[TD]
StringList[/TD]
[TD]
Notes[/TD]
[/TR]
[TR]
[TD]LOS ANGELES AK059 hvlaca1-ars3 US 11/7-5/3 THIS is more TEXT[/TD]
[TD]AK059[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]AK059, US[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Pacoima AC147 and AC146 vnnyca2-ars14 US 12/8-4/0 HSD, VIDEO and PHONE Offline[/TD]
[TD]AC147[/TD]
[TD]AC146[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD]AC147, AC146, US[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Rowland Heights - RH003 & RH015X - breaca1-ars5 US 11/0-5/2 - HSO & Phone - Offline[/TD]
[TD]RH003[/TD]
[TD]RH015X[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD]RH003, RH015X, US[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]WEST HOLLYWOOD WH007 snmnca1-ars8 3/8.0 - 4/3.0 HSD/VOIP Offline[/TD]
[TD]WH007[/TD]
[TD]3/8.0[/TD]
[TD]-[/TD]
[TD]4/3.0[/TD]
[TD][/TD]
[TD]WH007, 3/8.0, -, 4/3.0[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]ARTESIA AA021 AA022 AA023 AA024 lkwdca1-bsr2 1/0/1/0 - 1/2/3/0 HSD, VOIP Offline[/TD]
[TD]AA021[/TD]
[TD]AA022[/TD]
[TD]AA023[/TD]
[TD]AA024[/TD]
[TD][/TD]
[TD]AA021, AA022, AA023, AA024[/TD]
[TD]
Perfect![/TD]
[/TR]
[TR]
[TD]Thousand Oaks TO117 agorca1-ars5 3/0.0-3/3.0 HSO and Phone Offline[/TD]
[TD]TO117[/TD]
[TD]3/0.0-3/3.0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]TO117, 3/0.0-3/3.0[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Los Angeles AH252 AH253 AH254 AH341 stcyca1-ars1 HSD/VOIP Offline[/TD]
[TD]AH252[/TD]
[TD]AH253[/TD]
[TD]AH254[/TD]
[TD]AH341[/TD]
[TD][/TD]
[TD]AH252, AH253, AH254, AH341[/TD]
[TD]
Perfect![/TD]
[/TR]
[TR]
[TD]Carson CA022, CA041, CA042X, CA044 crsnca1-ars2 12/16-4/4 All Services Offline[/TD]
[TD]CA022,[/TD]
[TD]CA041,[/TD]
[TD]CA042X,[/TD]
[TD]CA044[/TD]
[TD][/TD]
[TD]CA022,, CA041,, CA042X,, CA044[/TD]
[TD]
Almost perfect - extra commas[/TD]
[/TR]
[TR]
[TD]Compton CP023 CP019 CP015 cmtnca1-bsr8 1/1/0/0 1/2/3/0 All services Offline[/TD]
[TD]CP023[/TD]
[TD]CP019[/TD]
[TD]CP015[/TD]
[TD]1/1/0/0[/TD]
[TD][/TD]
[TD]CP023, CP019, CP015, 1/1/0/0[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Thousand Oaks TO119, TO117 agorca1-ars4-ars5 1/4.0 1/7.0 Hsd, Voice Offline[/TD]
[TD]TO119,[/TD]
[TD]TO117[/TD]
[TD]1/4.0[/TD]
[TD]1/7.0[/TD]
[TD][/TD]
[TD]TO119,, TO117, 1/4.0, 1/7.0[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Carson CA045 crsnca1-ars2.socal.rr.com 5/8.0 5/11.0 HSD, Voice Offline[/TD]
[TD]CA045[/TD]
[TD]5/8.0[/TD]
[TD]5/11.0[/TD]
[TD][/TD]
[TD][/TD]
[TD]CA045, 5/8.0, 5/11.0[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Port Hueneme NV001, NV002, and NV005 oxnrca1-ars3 4/8.0 thru 4/11.0 HSO and Voice Offline[/TD]
[TD]NV001,[/TD]
[TD]NV002,[/TD]
[TD]NV005[/TD]
[TD]4/8.0[/TD]
[TD][/TD]
[TD]NV001,, NV002,, NV005, 4/8.0[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Los Angeles AH017, AH111, AH112 egrkca1-ars3 2/0.0 2/3.0 HSD, Voice Offline[/TD]
[TD]AH017,[/TD]
[TD]AH111,[/TD]
[TD]AH112[/TD]
[TD]2/0.0[/TD]
[TD][/TD]
[TD]AH017,, AH111,, AH112, 2/0.0[/TD]
[TD]Extra commas, extra info[/TD]
[/TR]
[TR]
[TD]WOODLAND HILLS WO001 WO030 cnpkca3-ars7 1/2 HSD VOIP OFFLINE[/TD]
[TD]WO001[/TD]
[TD]WO030[/TD]
[TD]1/2[/TD]
[TD][/TD]
[TD][/TD]
[TD]WO001, WO030, 1/2[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Tujunga AD041 AD042 AD046 tjgaca1-ars1 3/8 3/10 HSD Phone Offline[/TD]
[TD]AD041[/TD]
[TD]AD042[/TD]
[TD]AD046[/TD]
[TD]3/10[/TD]
[TD][/TD]
[TD]AD041, AD042, AD046, 3/10[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]South Pasadena San Marino PM013 PM016 SO002 SO006 spsdca1-ars1 Multiple blades HSOand voice Offline[/TD]
[TD]PM013[/TD]
[TD]PM016[/TD]
[TD]SO002[/TD]
[TD]SO006[/TD]
[TD][/TD]
[TD]PM013, PM016, SO002, SO006[/TD]
[TD]
Perfect![/TD]
[/TR]
[TR]
[TD]ARCADIA AR023 AR024 mnrvca1-ars3 US 13/8-2/10 HSO Phone Offline[/TD]
[TD]AR023[/TD]
[TD]AR024[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD]AR023, AR024, US[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Pico Rivera PR098 PR096 whtrca1-ars3 1/8 1/11 HSD PHone Offline[/TD]
[TD]PR098[/TD]
[TD]PR096[/TD]
[TD]1/11[/TD]
[TD][/TD]
[TD][/TD]
[TD]PR098, PR096, 1/11[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Inglewood IW058 IW059 IW060I W063 igwdca1-ars1 Multiple blades HSO and voice Offline[/TD]
[TD]IW058[/TD]
[TD]IW059[/TD]
[TD]IW060I[/TD]
[TD][/TD]
[TD][/TD]
[TD]IW058, IW059, IW060I[/TD]
[TD]
Missing last item - original data entered wrong[/TD]
[/TR]
[TR]
[TD]Willowbrook WB009 cmtnca1-bsr2 1/3/0/0 1/3/3/0 HSD, Voice Offline[/TD]
[TD]WB009[/TD]
[TD]1/3/0/0[/TD]
[TD]1/3/3/0[/TD]
[TD][/TD]
[TD][/TD]
[TD]WB009, 1/3/0/0, 1/3/3/0[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Los Anglese AI382X bwlaca1-ars17 7/8.0 thru 7/11.0 HSO and Voice Offline[/TD]
[TD]AI382X[/TD]
[TD]7/8.0[/TD]
[TD]7/11.0[/TD]
[TD][/TD]
[TD][/TD]
[TD]AI382X, 7/8.0, 7/11.0[/TD]
[TD]Extra info[/TD]
[/TR]
[TR]
[TD]Santa Monica - SM047,49,51,52,5,6,7,8,9,10,13, - snmnca1-ars1 - HSO & Phone - Offline[/TD]
[TD]SM047,49,51,52,5,6,7,8,9,10,13,[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SM047,49,51,52,5,6,7,8,9,10,13,[/TD]
[TD]Extra info[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1227"]
<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks!
--
Jawnathin