Three things:
- Your title is not descriptive (Sql left function) and therefore does not meet the forum rules.
- We can't do anything with JPG files. Post a sample Excel worksheet so others can follow
- Could you be more descriptive as your explanation isn't clear?