Originally Posted by
Pete_UK
You have changed the requirements completely now. The solution I was working on was based on you having ROGAN J / JONES F and wanting J Rogan/F Jones as the output.
Do you still want to do that?
Pete
Thanks Pete. Appreciate the response greatly. If you can just do the current requirements per the thread that's what's needed. Working with the / symbol actually is pretty straight forward and basic (pretty silly by me to bother to include such a simple thing originally) because you can just find all the text to the left and right of that and then concatenate it all together at the end so it's figuring out the 'Jones F W' type stuff now that is what's left.
So far I've been able to count the characters in each word in a cell using the below where my data is in cell S2. If S2 contained 'ROGAN JONES F W' then the output of this formula would be '5 5 1 1'. Is there a way to then say find the first 1 and return it and all to the right of it?
Bookmarks