Hi,

Am Wed, 4 Mar 2015 11:32:41 -0800 (PST) schrieb gwc:

3ABN Three Angels Broadcasting Network 9393
5-MAX 5StarMAX SAP 314
BBGL Bases Loaded/Buzzer Beater/Goal Line 403
MALL Mercury 86/123/220
JTV Jewelry Television 83/227
NBC (KNBC) 4
ABC (KABC) 7

your data in column A:

=MID( A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",))))+1,99)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional