Get First Name from excel column

=LEFT(A1,FIND(" ",A1)-1)  returns true not the first name.   Is there something wrong with the code?
running32Asked:
Who is Participating?
 
jppintoCommented:
0
 
jppintoCommented:
Your formula is OK, isn't it working? Did you checked if you have any extra space at the beginning of your column?

Could you post sample data where you're applying your formula?
0
 
jppintoCommented:
You can see on the attached file a working sample...
Book2.xlsx
0
 
running32Author Commented:
Thanks
0
 
bitrefCommented:
You formula works successfully with me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.