Excel 2007 : Return 'TRUE' for cells that contain a letter?

[4am]

I have a spreadsheet that has codes in it. I have to separate the codes that contain a letter from the codes that do not. I'd like to use a simple function that will give me a 'TRUE' value for the codes that have letters in them.

Examples of the codes I have in my worksheet:

1234-AB would return TRUE
1394-38 would return FALSE
289-MX-399-4 would return TRUE
3-493-4949 would return FALSE

Any help appreciated! I'd like to do it without having to specify each letter I'm looking for, but if that's the only way I can do it, that is fine too.

Thank you!

[Ron Coderre]

With
A1: containing a string that may contain letters (A-Z)

This formula returns TRUE if any of the A1 characters is a letter...otherwise: FALSE

Please Login or Register  to view this content.

Does that help?

[NBVC]

This might also do the job...

=IF(A1="","",ISERR(SUBSTITUTE(A1,"-","")+0))

copied down.

where A1 contains first string to test.

[4am]

Thank you so much. The first formula worked great, so I did not try the other one. Love this forum! thanks again!