Set the number of characters in a column

B

bicheno

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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Table Preferred width is changed when pasting 1
remove alpha or non-numeric characters from cell 8
Can I automatically have a space after the content in an Excel cel 2
Text To Column max 26 characters 7
Math formulas possible with overstrike characters? 2
Column Autofit 2
Data Validation, Identify Duplicates and Limit imput 11

Top