Sorry to be so dim but as regards to these click here I am getting a bit confused!!! I now have starting in cell B2 AAROC18 001 which needs to be in cell L2 AAROC_18A and if a cell reads AAROC20D 001 it needs to read in cell L2 AAROC_20D and so on. Some may be AUA214 001 which need to be AUA2__14A or AUA214D 001 which needs to be AUA2__14D. Is VoG about!!
Thats excellant VoG. Is it also possible to incorparate into this formula if it is the following format? (FTGRAP14 001 to FTGRAP14A) and (FTGRAP18D to FTGRAP18D) and also (AR618 001 to AR6___18A) and (AR618D 001 to AR6___18D)or does that get to complicated!! Then I will have all possibilities covered. Thanks again.