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.

This thread is current as of June 17, 2014.

For more resources for Microsoft Excel