Boards
Excel Formulae Proper Lads Assemble!
Would there have been a quicker way to write this formulae, which ensures a cell is brought through as containing 15 characters no matter how many characters are in the original entry cell?
(IF(LEN(U7)=0,"_______________",IF(LEN(U7)=1,U7&"______________",IF(LEN(U7)=2,U7&"_____________",IF(LEN(U7)=3,U7&"____________",IF(LEN(U7)=4,U7&"___________",IF(LEN(U7)=5,U7&"__________",IF(LEN(U7)=6,U7&"_________",IF(LEN(U7)=7,U7&"________",IF(LEN(U7)=8,U7&"_______",IF(LEN(U7)=9,U7&"______",IF(LEN(U7)=10,U7&"_____",IF(LEN(U7)=11,U7&"____",IF(LEN(U7)=12,U7&"___",IF(LEN(U7)=13,U7&"__",IF(LEN(U7)=14,U7&"_",U7))))))))))))))))
?