Forum Discussion
Text to Columns - Single Split
Hello All, Is there a way to split by SPACE, but only the first time? --- Example Cells in a Column: Joe likes books. Bob like to eat shoes. Ron likes the sound of crunchy cookies. --- I w...
Hi DraygonTech,
You could use a combo formula using LEFT and FIND to achieve this. See below for my example formula. B2 would be the cell containing "Joe likes books" for example. Then simply copy this formula down the column.
=LEFT(B2, (FIND(" ", B2, 1)-1))
Let me know if this works for you. Best,