Excel - Extract string of characters

July 2017




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


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).