I am trying to figure a formula to insert spaces depending on the number of digits in a given cell. For example A1 has a 6, I need B2 to be a cell that has 6 spaces in it so I can then do A1&B2 to show as 0000006 (0's indicate spaces) Also, fore example if A1 was 12 I would need B2 to be a cell that shows 5 spaces so I can then do A1&B2 to show 0000012 (again 0's indicate spaces). SO in summary Column be would be cells with only spaces. Please let me know if this makes sense and if you have any ideas for me.
Thanks!
Thanks!