Separating Text
 

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?

Separating Text
 

Use the RIGHT function, or the MID function.

Hope this helps.

Pete

"Té" wrote in message
...
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?

Separating Text
 

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

"Té" wrote:

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?