Excel - Extract string of characters

October 2016


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:

Related :

This document entitled « Excel - Extract string of characters » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.