M
Michael
Mendel
Use the Concatenate function.
If the area code is in A1 and the Tel # is in A2.
Click in A3 and type =A1&A2.
Have a look at the result, if it is OK then drag A3 down
the rest of the column.
Regards
Michael
Use the Concatenate function.
If the area code is in A1 and the Tel # is in A2.
Click in A3 and type =A1&A2.
Have a look at the result, if it is OK then drag A3 down
the rest of the column.
Regards
Michael