- Jul 29, 2014
- Office Version
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.