How to get first characters or numbers from the value

In Excel there is a simple function LEFT, which is used to get first characters of value or to remove unwanted characters from the right side.


In this Excel table are ID composed of year and item number. We want to take the year from the ID value to another column.

First numbers of the value

The year in ID contains always 4 numbers. So we can use Excel function LEFT.




Result of LEFT function

Note: If you need more, try this article:

Add a comment »One comment to this article

  1. First character from string in Excel. Solved!


Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress