Separate two words in cell

[wally]

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

 

[Biff]

Hi!

Try this:

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

Biff

 

[wally]

Hi!

Try this:

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

Biff

Hi
It works great, thank you very much
WallyB

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Hi
It works great, thank you very much
WallyB