Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Append zeroes to CPF numbers with < 11 characters on LibreOffice
=IF(LEN(A1) < 11,CONCAT(REPT(0,11 - LEN(A1)), A1),A1)
=IF(LEN(A1) < 11,
CONCAT(
REPT(0,11 - LEN(A1)
),
A1),
A1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment