First name breakout
I always seem to be asked how to split out part of a name. Just earlier today I was asked how to break out just the first name in a list.
Well you can text to column the list delimited on the space or you can use the following code below to do it.
Quick and easy. I love these types of problems.
BEGINNER, LEFT, FIND