Try in C3 and copy down:
Formula:
=IF(LEFT(B4,5)="AAAA-",B3&SUBSTITUTE(B4,"AAAA-",""),IF(AND(LEFT(B3,5)<>"AAAA-",LEFT(B4,5)<>"AAAA-"),B3,""))
Buona fortuna!
Try in C3 and copy down:
Formula:
=IF(LEFT(B4,5)="AAAA-",B3&SUBSTITUTE(B4,"AAAA-",""),IF(AND(LEFT(B3,5)<>"AAAA-",LEFT(B4,5)<>"AAAA-"),B3,""))
Buona fortuna!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks