Any formula to convert entries like

123AAA456BBB
AA12BB4567CCC

to:

AAABBB
AABBCCC

i.e. simply removing the digits 0-9 from the entry?

Thanx in advance!

--
Best Regards,

Faraz

Hi Faraz, incase you are looking for a UDF

Function RemoveNums(strData As String) As String
Dim intTemp As Integer
For intTemp = 1 To Len(strData)
If Not IsNumeric(Mid(strData, intTemp, 1)) Then _
RemoveNums = RemoveNums & Mid(strData, intTemp, 1)
Next
End Function

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Any formula to convert entries like

123AAA456BBB
AA12BB4567CCC

to:

AAABBB
AABBCCC

i.e. simply removing the digits 0-9 from the entry?

Thanx in advance!

--
Best Regards,

Faraz

Hi Faraz

If you are looking for a formula solution you can try the below which uses a
helper cell. (Copied from a previous post)..Thought if this might help..

In cell A1 you have the text..
In cell B1 (helper column)
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBST ITUTE(A1,1,),2,),3,),4,),5,)

In cell C1
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBST ITUTE(B1,6,),7,),8,),9,),0,)




If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hi Faraz, incase you are looking for a UDF

Function RemoveNums(strData As String) As String
Dim intTemp As Integer
For intTemp = 1 To Len(strData)
If Not IsNumeric(Mid(strData, intTemp, 1)) Then _
RemoveNums = RemoveNums & Mid(strData, intTemp, 1)
Next
End Function

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Any formula to convert entries like

123AAA456BBB
AA12BB4567CCC

to:

AAABBB
AABBCCC

i.e. simply removing the digits 0-9 from the entry?

Thanx in advance!

--
Best Regards,

Faraz

Hello Faraz,

You will need a UDF for this, I think.

I suggest to use:
=RegExpReplace(A1,"\d","",FALSE,TRUE)

The function RegExpReplace you can find he
http://sulprobil.com/html/regexp.html

Regards,
Bernd