ExcelBanter - Set the number of characters in a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Set the number of characters in a column (https://www.excelbanter.com/excel-discussion-misc-queries/136579-re-set-number-characters-column.html)

Stefi

Set the number of characters in a column

=REPT(" ",6-LEN(A1))&A1&REPT(" ",6-LEN(B1))&B1
Regards,
Stefi

€žbicheno€ ezt Ã*rta:

Is it possible to format an Excel column for "fixed number of characters"
(including spaces) or something similar so that any entry in the column
automatically adopts that number of characters - eg 124 becomes space space
space 124 etc etc,
& so that when you concatenate 2 adjacent columns, the spaces prior to the
numbers in each cell get included in the concatenated cell rather than
omitted ?

All times are GMT +1. The time now is 10:25 PM.