2) When open in excel, cannot directly sorting the phone no, and this need to edit by highlight the phone no and copy and paste to Note to Find and Replace the space area and copy back to Excel file,
3) By highlight that modified column and paste value is the most simple, after that, it can be sorting now.
don't waste time to use formular to find and replace it,
However, use =LEFTB(text, num_bytes) to fix the digital no. Problem.
it will not accurate and waste time.
沒有留言:
張貼留言