Excel - Extract string of characters

December 2016




Issue


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.

Solution


Try this formula:
=LEFT(A1,NBCAR(A1)-6)

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.