** How do I change the name of a worksheet (on tab) to only the left 6 numbers in the name? **

[brad7989]

I have tabs that come in with a 6 digit number and then some other stuff after it and want my formatting macro to remove all of the extra stuff off of the name down there.

Thanks for your help!

 

[brad7989]

Examples are something as follows:

" 124555 Heythere "