chadlaw32
Board Regular
- Joined
- Jul 29, 2014
- Messages
- 84
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
I have a sheet that I will update weekly and one of the columns contains data like this "75 Modems Offline txmex001cme - cable-mac 38 · Node 10A1 & 2B2" The numbers at the from could be anything. How do I extract this part txmex001cme without using text to columns. I want to be able to paste data every week and have the sheet do all the work for me.