JG:

Try this formula in the uppermost cell of the column you want the #'s
to appear in and just autofill it down the column. =LEFT(A1,FIND("
",A1)-1)