Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I have numbers as below. When the numbers end I want everything removed to the adjacent column. I cant use text to columns as there are varying lengths etc. So a code or formula please.
P.S Some may not have letters etc after numbers for example WA2345
Before
Excel 2010
After
Excel 2010
P.S Some may not have letters etc after numbers for example WA2345
Before
Excel 2010
Row\Col | AE |
---|---|
15998 | WA11711N |
15999 | WA20293R |
16000 | WA22721N-WSD |
16001 | WA20563-OS |
16002 | WA20700N |
16003 | WA20562-OS |
Sheet: Sheet1 |
After
Excel 2010
Row\Col | AE | AF |
---|---|---|
15997 | WA20325 | N |
15998 | WA11711 | N |
15999 | WA20293 | R |
16000 | WA22721 | N-WSD |
16001 | WA20563 | -OS |
16002 | WA20700 | N |
16003 | WA20562 | -OS |
Sheet: Sheet1 |