Skip to main content
Helpful data formatting tips
Updated over 11 months ago

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

John Smith

Did this answer your question?