Excel Excel formulae to extract text string from a cell
Hi, I am having problems with an Excel formula, I was wondering if anyone can help? In column A, I have cells with a mix of numbers and text. The string is built according to: Company Name + B/S+ Number + Customer Name + Reference Rus-Hydro B 120 Smith 123456789 All elements can vary in length. I want to extract the Customer Name(eg Smith). I considered the Find and Mid function combination, but because everything varies, I can't get it to work. Can anybody help? Many thanks Simon
This question generated 26 answers. To proceed to the answers, click here.