excel can you get number in cell before and afteer comma code example Example: excel everything up to first space =LEFT(A1,(FIND(" ",A1,1)-1))