Fix phone numbers containing an x

[martinez_pedro]

So I have this spread sheet containing thousands of phone numbers but some of the phone numbers are in this format 9185556666x654 or 9185556666X6545 so would like to have a macro that can remove all the number after the X so the number would like this 9185556666 and can this macro work on selection since the phone numbers does not come in the same column all the time thanks for the help appreciated

[Colin Legg]

Hi,

Please Login or Register  to view this content.

Change the Range to suit. eg.

Please Login or Register  to view this content.

[jaslake]

Hi martinez_pedro
Try this

Please Login or Register  to view this content.

Place the code in a standard module and run from there. Let me know of issues.

[martinez_pedro]

Hi. Beforehand thank you for your help I was able to use the second the only modification I had to do was an error handler on the second code but it work great thank you
The reason I added a error handler was because if did not an x in the number than it failing by give an error

Please Login or Register  to view this content.