Column A = area code
Column B = first three digits
Column C = last four digits
Columns A and B never begin with a zero, so non-issue
Column C wouldn't display the fourth digit if there were leading zeros, so the formatting of the cells was changed to force four digits and prepend with 0's if needed
Problem: When attempting to concatenate (A1,B1,C1), the zeros would not populate...
My solution (as there were only 80ish of them) was to manually key in the single ' with the zeros - so 0001 was entered as '0001
Curious though, if this were to scale substantially larger, is there a formula that could push that single quote through a larger data set?
My sample data set is attached...
Bookmarks