Auto-correction of a cell after editing

[turkanet]

Dears,
I have below macro on sheet5, to make uppercase automatically after editing a cell.

Please Login or Register  to view this content.

i also need another macro for same page to clear spaces, dots, and characters like - _ from the selected cell in column D, after editing this cell. and both of these 2 macros should not prevent each other. Thank you in advance.

[MarMo]

turkanet,

pls use [CODE] tags to display code on the forum, as described in the forum's Rules item #3 :
see : https://www.excelforum.com/forum-rul...rum-rules.html

Thanks

[turkanet]

Any member to assist this request?

[jason.b75]

I think that your question was overlooked beacuse you have already flagged it as solved.

See if this does what you need

Please Login or Register  to view this content.

This will remove anything that is not a letter (a-z) or number (0-9),it will need to be edited if you need to keep any other specific characters including any accented letters i.e. á.
Is that what you need?

[turkanet]

Dear Jason,
Thank you for kind help. I have to clarify my request better like below;
adding to UCase event,

additional code must delete characters "- _ ( ) space dot comma" from selected cell in colomn D, and add plus sign (+) to same selected cell. for your information, this colomn is for telephone numbers, and i am trying to make cells automatically change numbers as "1 (808) 7555-1111" to "+180875551111" format.

[jason.b75]

Sorry, I missed the requirement for column D in your original post.

This should do what you need.

Please Login or Register  to view this content.

[turkanet]

This is perfect really. Thank you Jason for kind help.