CONCATENATE("0",cell)
The CONCATENATE function is a function in spreadsheets (such as Microsoft Excel or Google Sheets) that is used to join two or more strings of text together into a single cell. The formula "CONCATENATE("0", cell)" specifically adds the number "0" in front of the contents of a given cell.
For example, if the cell being referred to contains the number "123", the formula would produce the result "0123" because the "0" has been added to the beginning of the number.
This formula can be useful in situations where you need to add a leading zero to a number for formatting purposes, such as when working with phone numbers or ID numbers that require a certain number of digits.
%20(1).png){kind=avatar}
No comments:
Post a Comment