• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

OrganicWeb

Mailchimp Training & Consulting

  • Home
  • Services
    • Mailchimp Training
    • Mailchimp Consulting
  • Free Tools
    • Mailchimp Tutorials on YouTube
    • Subject Line Generator
    • Marketing Ideas Generator
    • Map Maker for Email
    • WhatsApp Click to Chat Generator
    • Avoid Email Going to Spam
    • Email Link Generator
    • Is Mailchimp Down?
    • Marketing Facts and Stats
  • Content
    • Blog
    • Videos
  • Contact & About
    • Contact
    • About

Mailchimp – how to correct the name field before import

One of the most common questions I get from Mailchimp customers is how to correct the first name field for contacts. Often the first name field includes the last name or is in upper or lower case. It isn’t simple in Mailchimp to, for example, separate the first and last names in a single field once the data are in Mailchimp.

In this video tutorial I show how to:

  • Remove extra and unwanted spaces in your contact list.
  • Change the case of first names so that the first letter of the name is uppercase and then the rest of the name is lowercase.
  • Separate first names and last names into separate fields. I show how to do this where you first and last names are space separated and comma separated.

Excel formulas to separate first and last names

The formulas I use in Excel, and demonstrate in the tutorial, are listed below.

How to separate names where a space is used as the separator

If your CSV or Excel file has first and last names separated by an empty space then here are the Excel formulas to use.

  • To remove empty spaces before the name: =TRIM(B2)
  • To change the case of the name to be uppercase first letter and lowercase for the rest of the name: =PROPER(B3)
  • To only show the first name from the name field: =IF(ISNUMBER(SEARCH(" ",D2)),LEFT(D2,(FIND(" ",D2,1)-1)),D2)
  • To only show the last name from the name field: =IF(ISNUMBER(SEARCH(" ",D2)),RIGHT(D2,LEN(D2)-FIND(" ",D2)),"")

How to separate names where a comma is used as the separator

If your CSV or Excel file has first and last names separated by a comma then here are the Excel formulas to use.

  • To remove empty spaces before the name: =TRIM(B2)
  • To change the case of the name to be uppercase first letter and lowercase for the rest of the name: =PROPER(B3)
  • To only show the first name from the name field: =IF(ISNUMBER(SEARCH(",",D2)),LEFT(D2,(FIND(",",D2,1)-1)),D2)
  • To only show the last name from the name field: =IF(ISNUMBER(SEARCH(",",D2)),RIGHT(D2,LEN(D2)-FIND(",",D2)),"")
  • To remove empty spaces before the last name: =TRIM(E2)
  • To remove empty spaces before the first name: =TRIM(F2)

Found this useful? Please share:

Related

  • How to add role-based emails to Mailchimp
  • How to Set a Default First Name in Mailchimp
  • How to Automatically Insert a First Name in Mailchimp

Filed Under: Marketing

Watch Gary in action

Gary frequently adds Mailchimp instructional videos to his YouTube channel. Subscribe to keep updated.

→  Subscribe   ←

How to add an editable attachment to a Mailchimp campaign.

How to add, and send, coupon codes in Mailchimp.

Reader Interactions

Leave a Reply Cancel reply

You are here: Home / Marketing / Mailchimp – how to correct the name field before import

Primary Sidebar

Mailchimp write about my work

Read on Mailchimp.com

Learn from a Mailchimp Pro Partner

Signup to receive info about Gary's Mailchimp beginner and advanced classes.

Sign up

Gary on Australian National Radio

Changes are coming to the Australian Spam Act

Read Gary's article in SmartCompany

Meet Gary, Mailchimp Expert

Gary is a Mailchimp Expert and Partner. He delivers Mailchimp training and consulting services in Australia, New Zealand and Singapore. Gary presents at Mailchimp events and hosts the first, and only, Australian Mailchimp sponsored event. He is M.B.A. qualified from Henley Business School, U.K.

Contact Gary for your Mailchimp needs

Footer

Customer Rating

Mailchimp Pro Partners

Contact

Contact Gary for all your Mailchimp training, consulting and integration needs.

Contact Gary.

Copyright © 2022 · Sitemap · ABN: 40800872179 · Privacy Policy · Terms of Service