11 junio, 2024

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.
doc add trailing space 1


arrow blue right bubble 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:
doc add trailing space 2
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:
doc add trailing space 3
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.
Tip.If
you want to quickly export range cells to a sparate text file or other
format file, please try to use the Kutools for Excel’s Export Range to File as shown in the following screenshot. It’s full function without limitation in 60 days, please download and have a free trial now.
doc export cell range to file


Recommended Productivity Tools for Excel

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *