number remove, data get

[gsrikanth]

in the excel
if i remove numbers like 0 1 2 upto 9
i have data
at a time whole numbers
how they remove
for each file iam replace zero with nospace, one with nospace i have many time

[JBeaucaire]

Please provide 3-4 examples of BEFORE and AFTER so we can see what you want.

[gsrikanth]

Originally Posted by JBeaucaire

Please provide 3-4 examples of BEFORE and AFTER so we can see what you want.

before
james( 33 )
( 71 )
stalin
mike( 17 )
( 37 )
1.5johnson
thompson( 37 )
( 34 )
1.43rosy
denis( 17 )

after
james
-
stalin
mike
-
johnson
thompson
-
rosy
denis

answer

[JBeaucaire]

I would use VBA for this, not a formula. Do you use VBA?

[gsrikanth]

Originally Posted by JBeaucaire

I would use VBA for this, not a formula. Do you use VBA?

yes for VBA

[JBeaucaire]

Put this new FUNCTION into a standard code module:

Option Explicit

Function CleanText(ByVal Txt As String) As String
Dim X As Long     'Code base by Rick Rothstein (MVP - Excel)
    For X = 1 To Len(Txt)
        If Mid(Txt, X, 1) Like "*[!A-Za-z]*" Then Mid(Txt, X, 1) = Chr(1) ' Leave only letters
    Next
    CleanText = Replace(Txt, Chr(1), "")
End Function

Now, use this as a formula. Your strings are in column A, in B1 enter:

=CLEANTEXT(A1)

...and copy down.