How to add trailing spaces to text in Excel?
When we copy the cell values from a sheet to a notepad, the contents may be placed untidily as the cell values are in different length as below screenshot shown. In this case, we can add trailing space to each cell value to keep them in the same length for neat and tidy look.
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
To keep the value in a same length for looking tidily, you can add trailing space to each of them.
Select a blank cell, and type this formula =LEFT(A1 & REPT(" ",10),10), drag fill handle to over the cells which need this formula. See screenshot:
Now each cell value has been in the same text length, and when you copy them to a notepad, it list neatly and tidily. See screenshot:
Note: in the formula, A1 is the cell you want to add trailing spaces, 10 indicates to specify the length of the value as 10 characters, you can change them as you need.