+ Reply to Thread
Results 1 to 6 of 6

Costa Rica phone numbers

Hybrid View

napoelonguerra Costa Rica phone numbers 03-15-2008, 07:31 PM
shg Try =CHOOSE(LEFT(A1,1) + 1,... 03-15-2008, 07:41 PM
napoelonguerra Costa Rica phone number 03-18-2008, 10:47 AM
darkyam =if(or(left(a1,1)="3",left(a1,... 03-18-2008, 10:53 AM
Portuga In Spanish ... 03-18-2008, 11:04 AM
napoelonguerra Hi All, Thanks Portuga and... 03-20-2008, 09:19 PM
  1. 03-18-2008, 10:47 AM #1
    napoelonguerra is offline
    Registered User
    Join Date
    02-18-2008
    Location
    Costa Rica
    Posts
    3

    Costa Rica phone number

    Hi "shg",

    thanks for the try, but the formula you provided does not do anything anywhere. I've tried to copy it / type it / whatever it, but there is no reaction on the data.

    Saludos,

    Napoleon
    Reply With QuoteRegister To Reply
  2. 03-18-2008, 10:53 AM #2
    darkyam is offline
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    =if(or(left(a1,1)="3",left(a1,1)="8",left(a1,1)="9"),8,2)&a1
    Note: for some reason, when I post this, it is putting spaces in the formula. You will need to remove these for it to work.
    Last edited by darkyam; 03-18-2008 at 10:56 AM.
    Reply With QuoteRegister To Reply
  3. 03-18-2008, 11:04 AM #3
    Portuga is offline
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    In Spanish

    =SI(O(IZQUIERDA(A1;1)="2";IZQUIERDA(A1;1)="4";IZQUIERDA(A1;1)="5";IZQUIERDA(A1;1)="6";IZQUIERDA(A1;1)="7");CONCATENAR(2;A1);SI(O(IZQUIERDA(A1;1)="3";IZQUIERDA(A1;1)="6";CONCATENAR(2;A1);(IZQUIERDA(A1;1)="9"));CONCATENAR(8;A1);""))

    In English
    =IF(OR(LEFT(A1;1)="2";LEFT(A1;1)="4";LEFT(A1;1)="5";LEFT(A1;1)="6";LEFT(A1;1)="7");CONCATENATE(2;A1);IF(OR(LEFT(A1;1)="3";LEFT(A1;1)="6";CONCATENATE(2;A1);(LEFT(A1;1)="9"));CONCATENATE(8;A1);""))
    ___________________________

    TO MODERATORS:
    Sometimes when posting (as is the case) Random spaces appear in the text. Specially bothering if we are talking formulas...
    Last edited by Portuga; 03-18-2008 at 11:23 AM.
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution
    Reply With QuoteRegister To Reply
  4. 03-20-2008, 09:19 PM #4
    napoelonguerra is offline
    Registered User
    Join Date
    02-18-2008
    Location
    Costa Rica
    Posts
    3
    Hi All,

    Thanks Portuga and Darkyam,

    It sort of worked. I had the reedit a few numbers, but overall it did the trick. Most work was deleting many instances of "#VALUE!" where the formula encountered blank fields. On some international phone numbers it changed to XXXXX + E.11 or something.

    ...and now I'll see if those numbers can be imported into my cell-phone without too much trouble.

    Anyway, thanks again for the help, and saludos from sunny Costa Rica,

    Napoleon
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1