Thread: Seperate First and Surnames

Hi. Im sure this will be an easy one for some of you guys.


I have 1 column containing first and second names seperated with a space.

I would like to split the first and second names into 2 seperate columns.


So for example

|__Bob Smith__|

Becomes

|__Bob__|__Smith__|

Thankyou.

Hi

Data, text to columns, deliminted and select space as the delimiter.

HTH

rylo

Hi
Col B =LEFT(A1,SEARCH(" ",A1)-1)
Col C =MID(A1,SEARCH(" ",A1)+1,100)
Drag the formula till the end of data
Ravi

Is this really possible to do in excel. Wow thats really gr8 and really time saving technique. Thanks for telling the formula.
Regards
HughesNet Blog
Satellite Internet Blog