Hello! I would greatly appreciate your support with the situation bellow.
Column A – here I will add different serial numbers of different lengths; the maximum length is 7 characters
Column B – the maximum length of characters must be 7 for all the cells in this column; I need to add here a formula that does the following:
1. brings the values from Column A
2. if the values from Column A have less than 7 characters it automatically adds at the beginning of the string of characters the value "0" (zero), in each cell as many times it is necessary in order to reach the number of 7 characters.
Column A Column B
74323 0074323 (2 zeroes must be added in front to reach 7 characters)
4588996 4588996 (no zeroes added because the series in Col A already has 7 characters)
5463 0005463 (3 zeroes must be added in front to reach 7 characters)
I was thinking of a formula similar to the one bellow, only that I do not know what criteria to add to the concatenate function, is possible.
=IF(LEN(A1)<7, CONCATENATE("0",A1), A1)
Bookmarks