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.
Add trailing spaces to text with formula
Add trailing spaces to text with formula
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.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
