tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone
this seamed easy but total stuck thanks to excel being soooo clever!
I have a list of codes like this "TW-RE-4-2-0" i.e ="Letters-More Letters-Numbers-Numbers-Numbers"
now what i want to do is remove the Letters and the first two "-" so i'm left with "4-2-0" (Numbers-Numbers-Numbers")
but everytime i remove the letters excel turn whats left into a date 04/02/00
how can i so i need a macro to do this to all the cells with data in column J
please help if you can
Thanks
Tony
this seamed easy but total stuck thanks to excel being soooo clever!
I have a list of codes like this "TW-RE-4-2-0" i.e ="Letters-More Letters-Numbers-Numbers-Numbers"
now what i want to do is remove the Letters and the first two "-" so i'm left with "4-2-0" (Numbers-Numbers-Numbers")
but everytime i remove the letters excel turn whats left into a date 04/02/00
how can i so i need a macro to do this to all the cells with data in column J
please help if you can
Thanks
Tony