Excel Worksheet Tips: Remove First and Last Character From a String
Perhaps you have a list of data that you wish to remove the first and last characters. For example, there is a list of values similar to these:
What you are after is the strings inside the inverted commas. You could go through each entry and edit them, or using the formula below:
Using this formula, it will format the results to look like this:
If you wish to remove two characters from the ends, change the -1 values to -2.
Or perhaps you only want to remove the FIRST character. If so, use the following code:
Or to remove the LAST character, use the following code:
Come check out the directory for the rest of my excel tips!