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.


No comments:

Post a Comment