that would work but I am using a web query to import the data and I update it
everyday. Instead of having to do the sort thing everyday I would like a
formua. Any ideas? Thanks.

"Gary''s Student" wrote:

Select the cells in column B and pull-down:

Data Text to Columns..

Use the space as the separator and pick a convenient destination column.
Tell the Wizard to only import the field with the "4" in it


--
Gary''s Student - gsnu200750


"Jambruins" wrote:

In cell B239 I have the following text
Carolina 3 at Pittsburgh 4 (SO)

All of column B is like this except with different team names.

I would like a formula to pull out the number 4. Any idea how to do this?
I have been trying to use the right command with the find command but I can't
quite get it. Thanks.