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:
=LEFT(A1,NBCAR(A1)-6)
Related
- Excel - Extract string of characters
- Excel - Modify a string of characters » How-To - Excel
- Excel/VBA - Deleting a string of character in a range of cells » How-To - Excel
- Excel - Extract a list from 2 columns » How-To - Excel
- Excel - Extracting data from specified columns » How-To - Excel
- Excel - Extract words in uppercase » How-To - Excel