Break text

[arn0ldas]

hello i need some help. in COLUMN A i have text in one cell i need break this text in two cell COLUMN B and COLUMN C

Please Login or Register  to view this content.

[playaller]

If your data starts in A2 paste the below codes and drag down.

Paste in B2 to keep everything before the space:

Please Login or Register  to view this content.

Paste in C2 to keep everything after the space:

Please Login or Register  to view this content.

[FDibbins]

2 other options...
Option 1
=LEFT(A1,SEARCH(" ",A1,1)-1)
and
=MID(A1,SEARCH(" ",A1,1)+1,99)

Option 2
Use Text2Columns with space as the delimiter