#1
|
||||
|
||||
Add Standard Prefix To Cells
Hi friends, I'm doing some housekeeping for my friends & family contact numbers. I want to have a standard prefix for them. The prefix that I want is: +60 (Malaysia Country Code telephone number). In my worksheet now, I have 3 types of data (phone numbers): First type: 123456789 (no "+60" prefix) Second type: 0123456789 (no "+6" prefix) Third type: 60123456789 and +60123456789 (yes, this is what I want) My question: How do I check for all First type & Second type data and add the missing "+60" or "+6" prefix for them? Note: In my country Malaysia, standard telefon number is like this: +60123456789 or 60123456789. This happened to me because before this, I recorded this data using cell phone and I just type '0123456789'. When I transfer the contacts to Excel and sync the contacts via some softwares, they ignore zero '0' in front the telephone number, unless I'm saving the telephone number starting by six '6'. Thank you for your helps guys! |
Tags |
prefix |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Prefix "www." to Website Address | kjxavier | Excel | 1 | 03-05-2012 11:59 PM |
Word 2007 TOC Section Number w/Alpha Prefix? | Gwen Butler | Office | 2 | 09-29-2011 06:10 AM |
Find & Replace words with "/" prefix & suffix | tollanarama | Word | 4 | 01-25-2011 02:19 AM |
Prefix bug in subject email Outlook 2010, [english: 100%] | OfficeBug | Office | 1 | 10-25-2010 03:10 PM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |