Answers.Body: <p>You mean you want to re-generate first and last name from the addressee column? I assume you want to do this with an SQL query or with a script? If so, yes you can (but you have to be carefull as you are editing directly in the DB and such....). The table is civicrm_contact and the columns are: first_name, last_name and addressee_display.
  Otherwise I would recommend removing the contacts and starting over I am afraid...</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-12T13:46:03.777Z
Answers.Text: It was more in the upload contacts, i have their first and last name in one column and i have bee putting it in addressee.
  
  Is there a way to directly put the first and last name in from the same column when uploading from a CSV file.
Answers.UserDisplayName: Jporter
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-12T14:39:16.593Z
Answers.Text: I see :-) No, I do not think you can do that in the standard import. You would probably have to integrate the 2 fields into 1 in your csv before you import.
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-12T13:38:45.793Z
Answers.LastActivityDate: 2015-05-12T13:38:45.793Z
Answers.UserDisplayName: ErikH - CiviCooP
Answers.Body: <p>If you are using excel / libre office / google sheets, you might want to use the built in spread sheet functionality to split the name column into two columns</p>
  
  <p><a href="https://www.google.com/webhp?sourceid=chrome-instant&amp;ion=1&amp;espv=2&amp;ie=UTF-8#q=how%20to%20split%20a%20name%20column%20in%20excel" rel="nofollow">https://www.google.com/webhp?sourceid=chrome-instant&amp;ion=1&amp;espv=2&amp;ie=UTF-8#q=how%20to%20split%20a%20name%20column%20in%20excel</a></p>
  
  <p>Might be a lot easier and faster to do so locally.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-12T14:17:16.053Z
Answers.LastActivityDate: 2015-05-12T14:17:16.053Z
Answers.UserDisplayName: Donald Lobo
Body: <p>I am uploading lots of CSV files and using addressee and addressee custom it will skip the first and last name and leave me to do it manually.</p>
  
  <p>edit: while renaming i realized I derped and addressee is something else.</p>
  
  <p>Is there anyway to get first and last names separated from one column</p>
  
Tags: <contacts>
Title: Uploading from CSV with first and last name in the came column
ThreadText: # Uploading from CSV with first and last name in the came column
  
  (Asked by: username_0 on 2015-05-12)
  
  I am uploading lots of CSV files and using addressee and addressee custom it will skip the first and last name and leave me to do it manually.
  
  edit: while renaming i realized I derped and addressee is something else.
  
  Is there anyway to get first and last names separated from one column
  
  **Tags:** contacts
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2015-05-12. Score: 3 | Accepted answer
  
  If you are using excel / libre office / google sheets, you might want to use the built in spread sheet functionality to split the name column into two columns
  
  <https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=how%20to%20split%20a%20name%20column%20in%20excel>
  
  Might be a lot easier and faster to do so locally.
  
  
  ---
  
  ### Answer by username_1 on 2015-05-12. Score: 1
  
  You mean you want to re-generate first and last name from the addressee column? I assume you want to do this with an SQL query or with a script? If so, yes you can (but you have to be carefull as you are editing directly in the DB and such....). The table is civicrm\_contact and the columns are: first\_name, last\_name and addressee\_display.
  Otherwise I would recommend removing the contacts and starting over I am afraid...
  
  > **Comments:**
  > **username_0**: It was more in the upload contacts, i have their first and last name in one column and i have bee putting it in addressee.  Is there a way to directly put the first and last name in from the same column when uploading from a CSV file.  
  > **username_1**: I see :-) No, I do not think you can do that in the standard import. You would probably have to integrate the 2 fields into 1 in your csv before you import.  
  
  ---
  
  