To remove the last character (s) from a text string, you can use a formula based on the LEFT and LEN functions. In the worksheet shown above, each city and country in column B ends with an asterisk (*) that we would like to remove.
For most of Excel users, sometimes, you need to delete first n characters from the beginning of the text strings or remove the last x characters from the end of the text strings as below screenshot shown. This article, I will introduce some handy tricks for solving this task quickly and easily in Excel.