Expanding Cells

[Mission]

Hello

Is there a formula to expand cells?


for example:

if the name "Jane Doe" is in cell a1

is there a formula that I can put in cell b1

that will put the 1st word (jane) in cell c1
and the 2nd word (doe) in cell d1

Thanks in advance for your help

[Pete_UK]

You can't have a formula in B1 that "pushes" data into another cell. Instead, you can put this formula in C1:

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

and this in D1:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

Hope this helps.

Pete