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