Importing lists - First Name, Last Name combined

Hi There,

Sorry if this is a simple question and is answered elsewhere - we couldn't find an answer anywhere.

We have a subscription list with the first and last names separated (In fact all our clients do). How do people combine the first and last names (without re-typing everything) so that the list is formatted correctly for upload into the system?

Any help would be much appreciated.

Cheers

style campaign style campaign, 7 years ago

In Excel use:

=CONCATENATE(A2," ",B2)

0r

=A2&" "&B2

See this old post:

http://www.mailbuild.com/blog/2006/11/tip_combining_first_and_last_n.html

- Anna

Mathew Mathew, 7 years ago

Thanks for answering that Anna! In addition, keep in mind that there are some types of names where it is more useful to keep the first and last name fields separate (if you want to use un-hyphenated double barrel names for example).

In that case, you'd just setup some custom fields to use for first and last name.


Get in touch with us on Twitter: http://twitter.com/campaignmonitor
We're also on Facebook: http://facebook.com/campaignmonitor
tobystokes, 7 years ago

@mathew, the CM system separates the name field into sub-fields of firstname and lastname, when used in personalisation tags, yes?
In this case, how would CM handle the splitting of an un-hypenated double barrel - would the firstname or the lastname get the unidentified name in the middle?

Incidentally, although i'm happy concatening in excel, i do find that the majority of lists supplied to me come separated this way. If I could identify firstname and lastname on import, and CM could then concat them to it's standard name field, that would be a very useful helper, imho.

tobystokes, 7 years ago

I'm going to partially answer myself - just noticed http://www.campaignmonitor.com/forums/viewtopic.php?id=2386

"For this kind of situation, you are best off either using [fullname] and outputting the entire field, or using custom fields to separate your names into first names and last name fields for full control. The automatic name field just takes the first word for first name, and the last word for last name."

my request for automatic concatenation still stands though!

Join 200,000 companies around the world that use Campaign Monitor to run email marketing campaigns that deliver results for their business.

Get started for free
1-888-533-8098