Hi, Any expert on formatting existing phone number. I want to remove first 2 digit from the column with 11 digit phone number ??
Hi, Any expert on formatting existing phone number. I want to remove first 2 digit from the column with 11 digit phone number ??
If your phone number is in A1 then in B1 type =mid(A1,3,9)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks