=LEFT(A1,FIND(" ",A1,1)-1)
Showing posts with label fx: Text. Show all posts
Showing posts with label fx: Text. Show all posts
Friday, February 24, 2017
Get first word of a cell
To extract first word from a cell, create a custom formula by combining LEFT() and FIND()
=LEFT(A1,FIND(" ",A1,1)-1)
=LEFT(A1,FIND(" ",A1,1)-1)
Subscribe to:
Posts (Atom)