Excel - Extract string of characters

April 2018

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 (https://ccm.net/).
Excel - The COS function
Excel - The LEFT function