Data Formatting Tips

Modified on Tue, 22 Nov 2022 at 02:42 PM

Now that we’ve shown you what the formatting requirements are in the Data Formatting Instructions, here is a list of tips to help you fix many of the formatting issues that you might encounter. Click on the instructions links below to see how you can make bulk changes to your data, avoiding the one-by-one changes you are probably imagining. Any questions, please visit to our Support Center or go back to the Data Formatting Instructions page.

Separating Cells - instructions

Split Text to Columns feature comes in handy when you want to quickly split the first name and the last name, or the username and domain name from email id, or the domain name from URLs.

BEFORE	AFTER (Member Splash Required Format)
John Smith	John	Smith

Combine Cells - instructions

If you have content in different cells and you want to combine it, a couple of useful functions are CONCATENATE and JOIN.

BEFORE		AFTER (Member Splash Required Format)
3422	Thomas Drive	3422 Thomas Drive

Phone Number Formatting - instructions

With a little know-how and effort, you can format phone numbers any way you’d like them to appear.

BEFORE	AFTER (Member Splash Required Format)
1234567890	123- 456-7890

Date Formatting - instructions

Customize existing dates into the format Member Splash requires with this tool.

BEFORE	AFTER (Member Splash Required Format)
02/16/1986	1986-02-16

Calculate Date of Birth - instructions

Quickly calculate age using the date of birth to determine if a member is an Adult or Child.

BEFORE		AFTER
current date: 11-Feb-2020	date of birth: 24-May-1878	current age in years: 41

Remove Duplicates - instructions

Removing duplicates is such a common thing people do, that there is now a dedicated option to quickly remove the duplicate records.

BEFORE	AFTER
John Smith John Smith	John Smith