On Aug 26, 2:30 pm, "Rick Rothstein \(MVP - VB\)"
wrote:
Would anyone know how to also isolate the three numbers in the "»
Atlantic City H.S. (01-0110-010)" to yield three difference cells
containing the numbers?

Try these...

1st Number
=================
=SUBSTITUTE(LEFT(A5,FIND("-",A5)-1),LEFT(A5,FIND("(",A5)),"")

2nd Number
=================
=SUBSTITUTE(LEFT(A5,FIND("-",A5,FIND("-",A5)+1)-1),LEFT(A5,FIND("-",A5)),"")

3rd Number
=================
=SUBSTITUTE(LEFT(A5,FIND(")",A5)-1),LEFT(A5,FIND("-",A5,FIND("-",A5)+1)),"")

Rick

Rick,

Thanks so much!

Everything is working well!

-Jon