Is there an easy way to get name field imported into Marketo that is not separated into first and last name? | Community
Skip to main content
Chris_Chariton
Chris_Chariton
Level 2
September 17, 2015
Question

Is there an easy way to get name field imported into Marketo that is not separated into first and last name?

  • September 17, 2015
  • 1 reply
  • 2833 views

I have a list to import into Marketo where the name field is not split into first and last name. Is there an easy way to get my name field separated into first and last name for import?  It won't populate the full name field as that is a marketo auto populated field.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Dan_Stevens_
Dan_Stevens_
Level 10
September 17, 2015

Your best bet is to separate this data in your spreadsheet prior to importing into Marketo.  Here's one of many guides online: https://support.office.com/en-us/article/Split-names-by-using-the-Convert-Text-to-Columns-Wizard-39f7b055-6b39-4cb5-9512…

    Yoav_Guttman1
    Yoav_Guttman1
    Level 4
    December 13, 2018

    but this only works if you everyone has only a First and Last name, with no spaces. Right now, I am working on a list with like 80 names (of 2K) that this does not work for and so will have to do it manually.

    Yoav_Guttman1
    Yoav_Guttman1
    Level 4
    December 13, 2018

    so what I am doing as a next step is concatenating all the last name value cells and putting them into 1 cell. then i will manually check and adjust any double first names, etc.

    Terms & ConditionsAccessibility statement

    Loading footer...