monkeyharris
Active Member
- Joined
- Jan 20, 2008
- Messages
- 358
- Office Version
- 365
- Platform
- Windows
I've seen references to this on-line but nothing seems to work.
In column F from F2 i have various text strings IE: "CPI Beaconsfield", "Diverscite Pleinbois", "Hodge Clemco" etc etc... I want to extract the second word so in E2 onwards it reads Beaconsfield, Pleinbois, Clemco etc.......
In column F from F2 i have various text strings IE: "CPI Beaconsfield", "Diverscite Pleinbois", "Hodge Clemco" etc etc... I want to extract the second word so in E2 onwards it reads Beaconsfield, Pleinbois, Clemco etc.......