Automatically Put 18 charcter

[sauk304]

Hi Excel Gurus,

is there any formula that can be use to automatically put 10 character in records
example :

Cells A1 = 123 - add 7 space (using space bar) at the end of record.
Cells A2 = 1234 - add 6 space (using space bar) at the end of record.
Cells A3 = 12345 - add 5 space (using space bar) at the end of record.

currently in using LEN formula and filter by character, then copy the formula using filter.

 

[NBVC]

In another column add formula:

=A1&REPT(" ",10-LEN(A1))

copied down

Then you can copy this column and paste special >> values over the original column, if desired.