Excel Text to Columns in Tableau (SPLIT Function)

By: Oliver Linley

Ollie lives in Cape Town, South Africa, and is passionate about all things data - and all things Tableau! If you have a question, feel free to reach out to him directly via email.

In Excel, we can use Text to Columns to split a string. But what about in Tableau?

Tableau has a built-in function called SPLIT() that allows us to split strings into multiple columns. We’ll take a look at how to indicate to Tableau the number of columns we want to see and how to understand where to split the string.

Want to see how to split names, email address or phone numbers to isolate the meaningful information from the text string? Check out these examples!

Resources

Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!

Set Actions in Tableau (Proportional Brushing, Asymmetric Drilldown, Color Scaling)

Data Dashboard Design Best Practices

0