Truncating in Excel, additionally referred to as the TRUNC function, is used to simplify statistics. It permits you to estimate the number without determining the exact digits after a positive factor inside the string of integers. It would not round off numbers but as a substitute shows more than a few to a precise range of decimal places. The imprecise integers are regularly changed with zeros to suggest the dimensions of the variety without being precise. In Excel, you can decide the number of digits you want to truncate to achieve a standard accuracy level for your data You can use unique capabilities to truncate textual content in Excel because text strings don't include decimals. You decide what number of characters you need to be displayed within the textual content string.

Truncating the Text by using the RIGHT and LEFT Formulas

The LEFT and RIGHT formulations are constructed at the identical premise, though the LEFT formula shows characters from the left aspect of your cell's textual content and the RIGHT method shows characters from the right.

RIGHT function. =RIGHT (text,num_chars).LEFT function=LEFT (text, num_chars).Here are the complete formulas.

1.    Select the cell where you want the truncated text to appear.

2.   Get into the Formulas tab, click the Insert Function button, and insert the Left function. Enter A7 in the Text input box, and E13 in the Num_chars input box.

3.   If we want to extract the first three numbers from the left in cell B2, how can we realize it? Get into the Formulas tab, click Insert Function, and insert the Right function. Enter B2 in the Text input box, and 3 in the Num_chars input box.

The LEFT and RIGHT functions are similar. The only difference is the starting position. The RIGHT function starts to extract characters from the proper to the left, even as the LEFT function starts off evolving the extraction from the left to the proper.

Truncating Text Using the MID Formula

=MID(text, start_num, num_chars)Here is the complete formula.

MID chops character off of the beginning and cease your preferred cell’s text. To install, the MID formulation, you type “=MID (Cell Name, Starting Character Number, Number of characters to show)” without the citation marks.

1.   Select the cell where you want the truncated text to appear.

2.   Click Insert Function to insert the MID function.

Splitting Text into Multiple Columns

1.   Select the cell you wish to split up.

2.   Select Text to Columns in Data Tab.

3.   After clicking on the Text to Columns window will pop up, called “Convert Text to Columns Wizard Step 1 of 3. Select Fixed Width and click the Next button.

4.This window suggests 3 options. If you want to create a damaged line, click on the location where you need the textual content to interrupt. If you need to delete the wreck line, double-click on the road. To alter the road, click and drag it across the records.

5.Click on Finish Button.

Did you learn about how to Truncate text in excel? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides. You can also download WPS Office to edit word documents, excel, and PowerPoint for free of cost. Download now! And get an enjoyable and easy working experience.