Separate two words in cell
 

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

Separate two words in cell
 

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

Separate two words in cell
 

Biff wrote:
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

Hi
It works great, thank you very much
WallyB

Separate two words in cell
 

You're welcome. Thanks for the feedback!

Biff

"wally" wrote in message
oups.com...

Biff wrote:
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

Hi
It works great, thank you very much
WallyB