Hello
I have a large table of data (15000 lines plus) where the majority of the lines in the data contain a string of text starting with 'MC' followed by two or more numeric characters, forward slashes and possibly other characters. I'm trying to write a formula that will allow me to pull out the 'MC...' string (ie: 'MC' plus however many numbers follow 'MC') without then pulling out other parts of the text.
Is this possible? One idea I had was using MID to locate where MC starts in the text string, and then finding the next alphabet character following MC, and therefore whatever text is between these two points is the string I need, ie:
xxxx MC 02/03 xxxx
'MC' starts at 6
The next alphabet character after 'MC' (ie: x) starts at 15
so a MID function can then pull out the string between 6 and 15
If anyone can help with this, or has an easier way to do this I'd be very grateful!
Thanks
Kenny
Bookmarks