VBA or MACRO help!

[fletcher.carpenter]

I don't know a lot about programing or code.
I need to write a Macro or use some code to take cell phone numbers from an excel spreadsheet and eliminate the dashes
eg 480-123-4567 would become 4801234567
Then I need to take all of those numbers and attach @tmomail.net or @vtext.com to the end of it, then take all of those phone numbers turned email addresses and send a message through windows mail.
I have heard of this being done, but do not have the code.

[Mikerowaved]

You might get a better answer posing your question to a forum that deals exclusively in VBA coding, such as THIS one.

[jonesrk]

You can just use the SUBSTITUTE function eg SUBSTITUTE(a1, "-", "") if a1 had the phone number

[marianomarini]

In Italian is: CONCATENA(SOSTITUISCI(A1;"-";"");"@vtext.com")
In English (I suppose): LINK(SUBSTITUTE(A1;"-";"");"@vtext.com")
This work with OpenOffice.org

[lajackson]

In Italian is: CONCATENA(SOSTITUISCI(A1;"-";"");"@vtext.com")
In English (I suppose): LINK(SUBSTITUTE(A1;"-";"");"@vtext.com")
This work with OpenOffice.org

CONCATENATE instead of LINK will do it.

[marianomarini]

Thank lajackson. (So there is a word less longer in Italian than English!!)