Thread: Splitting text in a cell

Hi All,

I was wondering if there was a formula in which you can split text in a cell. something like an =FIND formula or even an "UN-CONCATENATE" as such.....

For Example

In Cell A1 I would have - BLOGS JOE
In Cell A2 I would have - CARTER WILLIAM
In Cell A3 I would have - SMITH JOHN

What I would like in cell B1 would be something like - "=FIND(" ",A1,and count back to the beginning of the cell and copy and paste details here)

What I would like in cell C1 would be something like - "=FIND(" ",A1,and count back to the end of the cell and copy and paste details here)

in order to give

A1 - BLOGS JOE
B1 - BLOGS
C1 - JOE

and then all I'd have to do is copy the formula down....

Thanks,
Jon

Paste the following formulas in the indicated cells

In B1:

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

In C1:

=MID(A1,FIND(" ",A1,1)+1,LEN(A1))

Thank you!!

That has worked just fine!!!