Excel - Extract string of characters

September 2017


I want to extract a string except the last x characters from a cell, and repeat this function to multiple cells.
It should be noted that the string are not always the same length.


Try this formula:


Published by aakai1056. Latest update on February 15, 2013 at 05:03 PM by aquarelle.
This document, titled "Excel - Extract string of characters," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).