How to Use Split, Custom Split, and Replace in Tableau

In this lesson, I walk through three of the most useful text functions in Tableau for cleaning and transforming string data:

• Split

• Custom Split

• Replace

We use a real-world example based on U.S. county data.

At first glance, it looks simple. You might just want to remove the word “County” from your geographic names.

But then you hit real data.

Louisiana uses “Parish.”

Other regions have different naming conventions.

And suddenly, a simple clean-up task requires more thought.

Inside this video, I’ll show you:

• When to use Split vs Custom Split

• When Replace is the better option

• How to handle inconsistent naming conventions

• Practical tips for cleaner geographic data

• How small text changes impact downstream analysis

This is the kind of data prep work that makes the rest of your dashboard development much easier.

You can download the workbook and dataset used in this lesson here:

👉 https://nlt.kit.com/split

If you’re serious about leveling up your Tableau skills, this is exactly the kind of practical training we go deeper on inside Next-Level Tableau.

Live classes.

Real use cases.

Advanced techniques you can apply immediately.

Learn more here:

👉 https://www.nextleveltableau.com/

----------

To go deeper, check out my courses:

→ Tableau Starter Kit - A beginner-friendly course designed to help you understand Tableau quickly - https://www.nextleveltableau.com/starterkit

→ Tableau Core Concepts - A comprehensive, self-paced course for Tableau users ready to level up - https://www.nextleveltableau.com/tcc

→ Join Next-Level Tableau - My most comprehensive Tableau program to help analysts become industry leaders, with the support of a like-minded community, and 1-to-1 help from me - https://www.nextleveltableau.com/

📩 The Dual Axis Newletter

Each week, I'll send you Tableau tips, tutorials, and strategies to design better dashboards, have more impactful, and stand out in your career: https://nlt.kit.com/