Is there a formula that will let me select only the first (or last) characters of a cell up to the first space?
Example:
Cell A1 contains; "14902115 First Part"
Cell A2 contains; "1402111 Second Part"
I want a formula in cells B1 & B2 that will return the characters 14902115 (B1) and 1402111 (B2)