simongilder
Board Regular
- Joined
- Nov 3, 2011
- Messages
- 68
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
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