Sweet, thanks for all your help guys.
Now: I am trying to invoke this script whenever someone pastes something:
For instance:
I place 123-987-6541 in Cell A1; I want it to automatically chnage to "1239876541" with the dashes gone. All automatically without having to manually run the macro- i...
Electric Pete
Thank you for that post; Can I change "mycell" to a range;
For instance an entire column (m1:M10000). I am having trouble changing to this. Your help will be appreciated.
Regards
Swertel'
I use a lot excel and is the only software available to me_ Hence the persistence. Thanks...
I have a VB script as follows:
How can I write loop for this:-
Sub format()
Dim X As Variant
X = range("M1")
X = Replace(X, "-", "", 1)
'The next line puts the cleaned up data back in J1
range("M1") = X
End Sub
Thank you all for your previous answers.
Is there a way where you could display both the formula and its out put in the same cell.
For instance:
I am using a "substitution" formula which removes dashes from numbers- I want the output of that formula to be displayed in the same cell.
OR:
If there is a way excel can automatically...
