Separating Text

[Té]

I am currently using the function "left" to separate last names and first
names from one column into two. Besides using the text to columns to
separate the fields is there a function I can use to separate first and last
name so first name is in column a and last name is in column b?

 

[Pete_UK]

Use the RIGHT function, or the MID function.

Hope this helps.

Pete

 

[pshepard]

Hi Té,

Assuming the name field is constructed as first name space last name:

Column A=LEFT(Name,FIND(" ",Name,1))

Column B=MID(Name,FIND(" ",Name,1),LEN(Name)-FIND(" ",Name,1)+1)

Hope this helps,
Peggy