I am looking for 2 different Macros
I have a list of 100 (A1:A10000) names followed by numbers in the same cell. I would like to create a macro that will remove the numbers but will leave the name alone and like wise, remove name but leave numbers. For example:
John123 will be changed to John with the remove number macro
12Pete will be changed to Pete with the remove number macro
1D2a3n will be changed to Dan with the remove number macro
AND
John123 will be changed to 123 with the remove Letter macro
12Pete will be changed to 12 with the remove letter macro
1D2a3n will be changed to 123 with the remove letter macro
Bookmarks