Hi!

Try this:

=MID(Sheet2!A1,FIND(" ",Sheet2!A1&" ")+1,255)

Biff

"wally" wrote in message
ups.com...
On sheet2 in cell a1 I have a number and name of a team which is: #1
Wonders. On sheet2 in cell a1, I would like a formula to give me the
name of the team only (Wonders), without the number (#1). Thanks for
your help.
WallyB