Excel in XL
An educational blog for excellence in Microsoft Excel
Friday, February 24, 2017
Get first word of a cell
To extract first word from a cell
, c
reate a custom formula by combining LEFT() and FIND()
=LEFT(A1,FIND(" ",A1,1)-1)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment