#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! |
#2
|
||||
|
||||
Hasn't anyone answered this yet, zuhl? Sheesh, I apologize; I've been away a few days but I didn't expect that. What you want here is to convert the number to text, then probably check to see whether the first two bytes are "60" or the first three are "+60". If they are not, you add the "+60"; then, whether you had to change it or not, convert back to numerics.
I'd give specific examples, but looking again it seems that your entries are a mix of numeric and text, and it isn't clear to me whether you want numeric or text results. Maybe it doesn't matter; maybe by now it's obvious to you what you want to do. But if not, confirm that the current values are a mix and tell me whether you want text or numeric results and we'll go into specifics. |
Tags |
prefix |
Thread Tools | |
Display Modes | |
|
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 |