=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.
=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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks