Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- `=IF(LEN(A2)<3, CONCATENATE(REPT("0", 3-LEN(A2)), A2), A2)`
- -------------
- | A | B |
- -------------
- | 1 | 001 |
- -------------
- | 2 | 002 |
- -------------
- | 31 | 031 |
- -------------
- | 45 | 045 |
- -------------
- | 500 | 500 |
- -------------
- `=CONCATENATE(REPT("0", 2), A2)`
- `=CONCATENATE(REPT("0", 3-LEN(A2)), A2)`
- `=IF(LEN(A2)<3, "APPLY REPT", "OUTPUT AS IS")`
- `=IF(LEN(A2)<3, CONCATENATE(REPT("0", 3-LEN(A2)), A2), A2)`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement