Convert 8 digits to leading alpha plus 6 digits following?

  • Thread starter Thread starter Lee Jeffery
  • Start date Start date
L

Lee Jeffery

I finally worked this out (I'm very much a dummy with any type o
formula!) although I'm sure someone else may have a better solution.
I'll post the IF statement here in case someone else is attempting
similar exercise and they may be able to adapt this. My 8 digit number
appear in Column F and start in Row 2:
=IF(LEFT(F2,1)="1","a"&MID(F2,2,6),IF(LEFT(F2,1)="2","b"&MID(F2,2,6),IF(LEFT(F2,1)="3","c"&MID(F2,2,6),IF(LEFT(F2,1)="4","d"&MID(F2,2,6),IF(LEFT(F2,1)="5","e"&MID(F2,2,6),IF(LEFT(F2,1)="6","f"&MID(F2,2,6),"g"&MID(F2,2,6)))))))


Lee Jeffery :
 
Hi!

Here's a shorter alternative:

=CHOOSE(LEFT(F2,1),"A","B","C","D","E","F","G")&MID(F2,2,6)

Biff
 
Back
Top