Hi everyone! First post
The below example in column 2 is what I'm looking to pull from column 1. I've been able to get the following to work on the "Sandra White" example, but not the other two. I'd like it so the names are extracted from column 1, and put into column 2. My current formula works on all examples, but I would like to strip out the "VIP" text, as currently any VIP names on the list are becoming "John VIP Smith", which isn't what I'm looking for. Unfortunately this much more selective stripping is a little beyond my skill as everything I've tried to do with my current approach gives me an error. Any help is greatly appreciated!
Smith, John VIP John Smith Jackson, Miss VIP Miss Jackson White, Sandra Sandra White
Bookmarks