Separate column after first space

Hi

I need help to separate a column after the first space found.

Example: "PC Need for speed" should be devided into to 2 columns with "PC" in one and "Need for speed" in another and "Xbox Fable lost chapters" should be "Xbox" and "Fable lost chapters"

When I use text to columns it can only separate at every point it finds a space.

Help please!

Hi,

In column B put

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

In column C put

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

and formula fill as required.

---

Originally Posted by peter233

Hi

I need help to separate a column after the first space found.

Example: "PC Need for speed" should be devided into to 2 columns with "PC" in one and "Need for speed" in another and "Xbox Fable lost chapters" should be "Xbox" and "Fable lost chapters"

When I use text to columns it can only separate at every point it finds a space.

Help please!

Thank you so much!

Originally Posted by Bryan Hessey

Hi,

In column B put

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

In column C put

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

and formula fill as required.

---

Having som problem doing a loop with these functions and I cant figure out whats wrong.

y = 5
Do While IsEmpty(Sheets(1).Cells(y, 1)) = False
Sheets(1).Cells(y, 3) = "=LEFT(B" & y & ";FIND("" """ & ";B" & y & ")-1)"
Sheets(1).Cells(y, 4) = "=MID(B" & y & ";FIND("" """ & ";B" & y & ")+1;9999)"
y = y + 1
Loop

I just get:
Run-time error 1004
Application-defined or object-defined error

Help!

y = 5
Do While IsEmpty(Sheets(1).Cells(y, 1)) = False
Sheets(1).Cells(y, 3).Value = "=LEFT(B" & y & ",FIND("" """ & ",B" & y & ")-1)"
Sheets(1).Cells(y, 4) = "=MID(B" & y & ",FIND("" """ & ",B" & y & ")+1,9999)"
y = y + 1
Loop


doesn't error, but it may not do what you originally intended.

---

Originally Posted by peter233

Having som problem doing a loop with these functions and I cant figure out whats wrong.

y = 5
Do While IsEmpty(Sheets(1).Cells(y, 1)) = False
Sheets(1).Cells(y, 3) = "=LEFT(B" & y & ";FIND("" """ & ";B" & y & ")-1)"
Sheets(1).Cells(y, 4) = "=MID(B" & y & ";FIND("" """ & ";B" & y & ")+1;9999)"
y = y + 1
Loop

I just get:
Run-time error 1004
Application-defined or object-defined error

Help!