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 |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article