annegrey
New Member
- Joined
- Nov 17, 2005
- Messages
- 32
Hi
I have data in a column similar to this:
AJ Smith
Alan Andrews
J&L Matthews
Mr & Mrs KL Mulder
Mr Alan Pinkett
Mr & Mrs John Guymer
I want to extract the name or initial in each case - so the only way I can imagine if to write a formula that takes the text between the last space and the 2nd last space. Any ideas?
Thanks in advance
AG
I have data in a column similar to this:
AJ Smith
Alan Andrews
J&L Matthews
Mr & Mrs KL Mulder
Mr Alan Pinkett
Mr & Mrs John Guymer
I want to extract the name or initial in each case - so the only way I can imagine if to write a formula that takes the text between the last space and the 2nd last space. Any ideas?
Thanks in advance
AG