Let's say I have first column where I will enter the quantity. In the second column I want the formula to automatically add spaces (depending on how many i want) after the quantity I inputted in the first column.
For example, I want the second column to always give me a fixed 5 character long.
So if I enter say 10 in the first column, the second column should give me 10 with three spaces after.
If I enter say 449 in the first column, the second column should give me 449 with two spaces after to complete my required 5 character length.
What's the formula for that?
Bookmarks