Mega Code Archive

 
Categories / MSOfficeExcel 2007 Tutorial / Text Functions
 

Get count of characters where the space is from left

=LEFT(A3,SEARCH(" ",A3)-1)