How to remove English language from an excel sheet having two different languages.
This code worked for me to remove foreign language
but how to remove English language and keep the foreign text.I don't have any idea about VBA. I just started now and found this code in some thread.Thanks in advance.![]()
Sub x() Dim rng As Range With CreateObject("vbscript.regexp") .Global = True .Pattern = "[^\d^\w^\s-\.\,]" For Each rng In Range("A1").CurrentRegion rng = .Replace(rng, "") Next rng End With End Sub
Bookmarks