Remove x characters from right of cell in Excel
Hello this video will present an approach using Excel functions, in order to remove a designated number of characters from the right of a cell in Excel. This is a follow-up to an earlier video, which presented a similar solution to mixed string cells • Remove x characters from left of cell...
Obviously we can aggregate the values in the range in column H, but we can't do the same for the corresponding cells in column I.
One approach is write a formula to extract a specified number of characters from the left of each cell.
First input the VALUE function because we want the output value to be an integer.
Then add the LEFT function, followed by the LEN function.
The example workbook can be found here http://spreadsheetvault.com/remove-x-...