|Hi, I'm wondering if there is a formula that will get a condition if a cell has less that 4 digits, to input extra spaces to add to 4 digits. E.g: |
one column has:
What I need is that the formula inputs extra spaces so it will add make it a four digit "number" like this
(where the asterisks are, I need spaces. This post won't take spaces before numbers, that's the reason for the asterisks)
I need this to line up the numbers to the right after I concatenate those numbers and paste them in a text file for so an old program can import it.