For example, if you had a big list of "something" and you need to make a list of it of the first 5 characters, or maybe last 10 characters. Hmmm.
Don't think more, excel has an inbuilt crop function to do that. Use "LEFT" function to retain characters starting from left side of the text, and use "RIGHT" function to retain characters starting from the right end of the text. This below figure should help you understand better.
Hope this helps!