When I copy it down, we get a list of first names.
So, this looks right, but actually there's a problem. The LEFT function extracts all characters up to and including the number you give it. That means we actually have a space at the end of all those first names.
To get rid of the space, I just need to make one simple change.
I need to subtract 1 from the result we get from FIND. That way, we won't pick up the space.
The final formula looks more complex, but really, it's just the LEFT function, with a little fancy footwork using FIND to figure out the number of characters we need to extract.
This is a simple example, but the idea is the same for all complex formulas.
Start with the big picture, and work in small steps to get the result you need.