How NOT to return #VALUE in Find?

[jetspin]

How does one NOT return #VALUE when the FIND Function does
not find its value?

For example... In the following I only want to put
a cell value in column B only if there is a phone number
in column A, but I also get the #VALUE when the FIND
functin fails. I don't want the #VALUE!

HERE IS A SAMPLE SHOWING THE FUNCTION....

COLUMN A COLUMN B
Row1 New York =IF(FIND("-",A1),A1)
Row2 Boston =IF(FIND("-",A2),A2)
Row3 403-333-2222 =IF(FIND("-",A3),A3)

HERE IS THE SAME SAMPLE SHOWING MY RESULTS...

COLUMN A COLUMN B
Row1 New York #VALUE
Row2 Boston #VALUE
Row3 403-333-2222 403-333-2222

THIS IS WANT I WANT...

COLUMN A COLUMN B
Row1 New York
Row2 Boston
Row3 403-333-2222 403-333-2222

THANKS!

 

[SkipVought]

Hi,

=IF(ISERROR(FIND("-",A1)),"",A1)

Skip,

http://www.TheOfficeExperts.com

 

[Dreamboat]

=if(left(a1,4)="-",a1,"&quot

Anne Troy

http://www.VBAExpress.com

 

[Dreamboat]

Of course, Skip's is more accurate. I was just trying to beat him to it.

Anne Troy

http://www.VBAExpress.com

 

[SkipVought]

Getting colder up there? Kinda nice here ;-)

Skip,

http://www.TheOfficeExperts.com

 

[Dreamboat]

22 degrees this morning when I got up

Anne Troy

http://www.VBAExpress.com

 

[SkipVought]

Ohhhhh, Anne. The frost is on the pumpkin! ;-)

Skip,

http://www.TheOfficeExperts.com

 

[Dreamboat]

Frost, hell. It's frozed up!

Anne Troy

http://www.VBAExpress.com