Hey all. I'm SURE this can be done but not a clue how...so I'm relying on all of you.
I have a description cell with text. The way it's written doesn't follow the syntax of another format I need it to be in. Here is an example:
"Alternator EP CUP 1-9U 1M EXT GOV" I need to take the "GOV" and put it at the beginning of that description instead of the end. I thought about selecting all cells with that data and then doing text to columns and then cutting out the GOV and adding it at the beginning and reversing the process....no luck there. This is out of a sheet with approximately 21000 lines of data. This GOV line exists about 4500 times.
Help?
Bookmarks