Isolate Numerical Data in Cell

[Rick Rothstein \(MVP - VB\)]

Okay, I think I see what you are saying... there is a trailing space

Nope, no other generalized white space is possible... otherwise I won't be
able to create a one-liner to handle it.<g>

Well, in thinking about it, that may not be entirely true. I would think
this should work...

Function School(str As String) As String
School = Trim(Split(Split(Application.WorksheetFunction. _
Clean(str), "(")(0), "»")(1))
End Function

Rick