|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Formula to recognize text only in a cell
Outstanding !!!
Tks,
Jim
"David McRitchie" wrote:
Hi Jim, (to find if a cell has any alpha character within)
Excel is rather lacking in having a TRANSLATE instruction to
change characters to other characters, so I would create a
User Defined Function (UDF).
.
Function Has_alpha(cell As String) As Boolean
Dim x As String, i As Long
For i = 1 To Len(cell)
If UCase(Mid(cell, i, 1)) = "A" And _
UCase(Mid(cell, i, 1)) <= "Z" Then
Has_alpha = True
Exit Function
End If
Next i
Has_alpha = False
End Function
To install see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
to use
=personal.xls!Has_alpha(A1)
=Has_alpha(A1)
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Jim May" wrote:
In cells A1:A3 I have:
(as text)
Cell Values Formula Needed
I need a formula in Cells B1:B3
to Recognize is a cells has characters A-Z
I can't quite figure out here, under pressure...
Can someone assist?
|