How to show only first nth characters in a cell string?
Have you ever tried to only show the first nth characters of a string in Excel as below screenshot shown? In this article, I introduce some tricks to help you show only the first nth characters in a cell string for you.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
In this case, I show only the first 3 characters in a string.
Select a blank cell which you will only show first 3 characters of the given string, and enter this formula =LEFT(A1,3), drag fill handle down to over the cells you want to show only first 3 characters. See screenshot: