First name breakout

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.

=LEFT(A2,FIND(” “,A2,1)-1)

Quick and easy. I love these types of problems.

BEGINNER, LEFT, FIND

Leave a Reply

Your email address will not be published. Required fields are marked *