Separating Text

  • Thread starter Thread starter Té
  • Start date Start date
T

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?
 
Use the RIGHT function, or the MID function.

Hope this helps.

Pete
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Separation Function 6
Formula for names 6
How to filter Unique values from Duplicates 6
Separate First Name MI and Last Name into three Cells 3
If not an exact match to left of comma, then ALERT 5
Need to alphabetize data from separate cells within same row 2
Text to columns question 5
Separating data in the same cell 1

Back
Top