Select a blank cell next to the phone number, take instance, C1, type this formula ="020"&A2 into it, and press Enter key, the drag the AutoFill handle from ...
確定! 回上一頁