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
No comments:
Post a Comment