Hi to all,
this formula in cell contains "AAAA-" merge cell B3:B4
=IF(LEFT(B4,5)="AAAA-",B3&SUBSTITUTE(B4,"AAAA-",""),"")
i can't edit for cells without "AAAA-"
see attached example
john
Hi to all,
this formula in cell contains "AAAA-" merge cell B3:B4
=IF(LEFT(B4,5)="AAAA-",B3&SUBSTITUTE(B4,"AAAA-",""),"")
i can't edit for cells without "AAAA-"
see attached example
john
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks