Results 1 to 6 of 6

Costa Rica phone numbers

Threaded 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. #4
    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.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1