how do I remove data from cells ex. (232)-555-1212 to 2325551212
how do I remove data from cells ex. (232)-555-1212 to 2325551212
Found this from experts-exchange:
Function KillNonNum(AnyVal As String)
Dim RegEx
Set RegEx = CreateObject("vbscript.regexp")
RegEx.Global = True
RegEx.Pattern = "[^\d\s]+"
KillNonNum = RegEx.Replace(AnyVal, "")
Set RegEx = Nothing
End Function
=KillNonNum(A1)
Last edited by Bearacade; 06-16-2006 at 01:40 PM.
Google is your best friend!
I'm sure there's a real formula, but I use the find & replace feature. Put
the character to remove (one at a time) in the Find box, leave the replace
box empty, and replace all. You have to select the column you want to
remove them from.
"Russ" <[email protected]> wrote in message
news:[email protected]...
> how do I remove data from cells ex. (232)-555-1212 to 2325551212
That is a formatting issue right click on the cell select format cell and
then change the format to general or whatever format you want.
"Russ" wrote:
> how do I remove data from cells ex. (232)-555-1212 to 2325551212
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks