> ## Content Index
> Fetch the complete content index at: https://www.vizney.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to Wrap Text in Tableau
- URL: https://www.vizney.com/wrap-text-in-tableau/
- Published: 2024-08-11T03:00:36.000Z
- Updated: 2024-09-19T03:44:05.000Z
- Description: By default, text in Tableau wraps based on available space and word breaks. However, if you want to control where the text breaks manually, here's how to do it.
- Author: Yehwan Hwang
- Tags: Tips & Tricks

We'll assume that the first word in the **Product Name** field of the Superstore dataset is the **Brand**. Let’s walk through how to separate the brand from the rest of the product name and add a line break between them.

![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2024/09/Product-name.png)

First, use the `SPLIT` function to extract the brand name, which is the text before the first space.

> SPLIT(\[Product Name\],' ',1)

Next, use the `FINDNTH` and `MID` functions to get the rest of the product name, excluding the brand.

> TRIM(MID(\[Product Name\],FINDNTH(\[Product Name\],' ',1)))

Finally, add a line break between the two by using the ASCII code `CHAR(10)`. The final calculation will look like this:

![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2024/09/image-6.png)

You could also wrap the line break in quotation marks like this, but for cleaner formulas, I recommend using the ASCII code method.

![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2024/09/Product-name--wrap-_bad.png)

Additionally, when trying to force a line break in measure names by adding multiple spaces, it’s better to use a cleaner approach. Refer to the guide below to create a header using a Placeholder for a more polished result.

[How to Merge Header Cells in TableauThis guide covers how to merge header cells, a common challenge when moving Excel-based documents into Tableau.![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/size/w256h256/2024/09/vizney_icon_b_1.0.png)VizneyColson Hwang![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2024/09/Merging-Header-Cells-1.png)](https://www.vizney.com/merge-header-cells-in-tableau/)