How to truncate text in Excel

You can watch a video tutorial here. Although Excel is well suited for calculation, it has several functions to manipulate and format text. These functions are useful especially when cleaning data. There may be a case where you want to truncate the text in a cell as all the text is not required.  The following … Read more