Hi!
If you want to do a left side padding, just do the following.
=REPT("0",7-LEN(A1))&A1
Where
0 = Character to be repeated
7 = Final desired lenght
A1 = Cell where to apply the transformation
For example, if the original content of cell A1 was TOTO, you will get 000TOTO
Subscribe to:
Post Comments
(Atom)
No comments:
Post a Comment