Here is a list of tips to help you fix many of the formatting issues that you might encounter. Each section has further instructions to see how you can make bulk changes to your data, avoiding the one-by-one changes you are probably imagining.
Separating Cells
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. More instructions
First and Last Name | First Name | Last Name |
John Smith | John | Smith |
Combine Cells
If you have content in different cells and you want to combine it, a couple of useful functions are CONCATENATE and JOIN. More instructions
Street Number | Street | Address |
3422 | Thomas Drive | 3422 Thomas Drive |
Phone Number Formatting
With a little know-how and effort, you can format phone numbers any way you’d like them to appear. More instructions
BEFORE | AFTER |
1234567890 | 123-456-7890 |
Date Formatting
Customize existing dates into the format Member Splash requires with this tool. More instructions
BEFORE | AFTER |
02/16/1986 | 1986-02-16 |
Calculate Date of Birth
Quickly calculate age using the date of birth to determine if a member is an Adult or Child. More instructions
Today | Date of Birth | Calculated Age |
11-Feb-2020 | 24-May-1978 | current age in years: 41 |
Remove Duplicates
Removing duplicates is such a common thing people do, that there is now a dedicated option to quickly remove the duplicate records. More instructions
BEFORE | AFTER |
John Smith | John Smith |