All,
I'm having problems recording a macro that will edit a cell that contains a phone number and delete the dashes from th phone number. Turning xxx-xxx-xxxx into xxxxxxxxxx.
The macro I recorded doesn't work. It takes whatever cell I recorded the macro in and simply inserts that number over the working number!
Any ideas?
Thanks.
I'm having problems recording a macro that will edit a cell that contains a phone number and delete the dashes from th phone number. Turning xxx-xxx-xxxx into xxxxxxxxxx.
The macro I recorded doesn't work. It takes whatever cell I recorded the macro in and simply inserts that number over the working number!
Any ideas?
Thanks.