Thursday, 22 May 2014

Excel - Deleting text from cell a space character

Try this:

=LEFT(A1,FIND(" ",A1)-1)

No comments:

Post a Comment