Forum Discussion
Phone numbers and area codes
I am trying to figure out the coding/function info needed to add area codes to phone numbers where it isn't already included. For example, in the list below, what formula can I put in, that would add...
I do not which number already including the area code, but the idea will be to check how many digits there using if function then, if the number in the cell has the required digits means it contain the area code otherwise include it,
I supposed the digits without the area code is 7 , and the area code +11 , so you can change them to fit your situation
=IF(LEN(A1< 7),CONCATENATE("+11",A1),A1)