Hi Guys
I'm wondering if it's possible to split a string by a keyword in excel.
eg. I have a list of products and companies and the strings are all variable length but contain a common keyword - ie "Shoes by John, Socks by Allison, Vacuum Cleaners by Frank"
I don't think i can use Left/Right/or Mid as they're based on number of characters, and inStr based on character position - All i want is to select everything before the word "by".
Is there a simple way to do this or will it involve some VB trickery?
I'm wondering if it's possible to split a string by a keyword in excel.
eg. I have a list of products and companies and the strings are all variable length but contain a common keyword - ie "Shoes by John, Socks by Allison, Vacuum Cleaners by Frank"
I don't think i can use Left/Right/or Mid as they're based on number of characters, and inStr based on character position - All i want is to select everything before the word "by".
Is there a simple way to do this or will it involve some VB trickery?
