The formula below is used to work out if a condition applies then insert (for example "A001" and the tab symbol, if not leave the cell blank, this forumla is repeated bout 40 times on the line.
C6 - =IF(AND(Days!S6="X",Days!E6="01"),IF(B6="Monday",TEXT("A001",CHAR(9)),IF(B6="Tuesday",TEXT("B001",CHAR(9)),IF(B6="Wednesday",TEXT("C001",CHAR(9)),IF(B6="Thursday",TEXT("D001",CHAR(9)),IF(B6="Friday",TEXT("E001",CHAR(9)),""))))),"")
Then, using the formula below adding them all up so they display as below
EE6 - =C6&D6&E6&F6&G6&H6&I6&J6&K6&L6&M6&N6&O6&P6&Q6&R6&S6&T6&U6&V6&W6&X6&Y6&Z6&AA6&AB6&AC6&AD6&AE6&AF6&AG6&AH6&AI6&AJ6&AK6&AL6&AM6&AN6&AO6&AP6&AQ6&AR6&AS6&AT6&AU6&AV6&AW6&AX6&AY6&AZ6&BA6&BB6&BC6&BD6&BE6&BF6&BG6&BH6&BI6&BJ6&BK6&BL6&BM6&BN6&BO6&BP6&BQ6&BR6&BS6&BT6&BU6&BV6&BW6&BX6&BY6&BZ6&CA6&CB6&CC6&CD6&CE6&CF6&CG6&CH6&CI6&CJ6&CK6&CL6&CM6&CN6&CO6&CP6&CQ6&CR6&CS6&CT6&CU6&CV6&CW6&CX6&CY6&CZ6&DA6&DB6&DC6&DD6&DE6&DF6&DG6&DH6&DI6&DJ6&DK6&DL6&DM6&DN6&DO6&DP6&DQ6&DR6&DS6&DT6&DU6&DV6&DW6&DX6&DY6&DZ6&EA6&EB6&EC6
displays - A001F001K001A002F002K002A003A005K005A019F063K063F077A089
the problem is that it no longer shows the tab symbol after each one
need it to look like (were the dots would be the tab symbol) - A001.F001.K001.A002.F002.K002.A003.A005.K005.A019.F063.
can anyone help?
C6 - =IF(AND(Days!S6="X",Days!E6="01"),IF(B6="Monday",TEXT("A001",CHAR(9)),IF(B6="Tuesday",TEXT("B001",CHAR(9)),IF(B6="Wednesday",TEXT("C001",CHAR(9)),IF(B6="Thursday",TEXT("D001",CHAR(9)),IF(B6="Friday",TEXT("E001",CHAR(9)),""))))),"")
Then, using the formula below adding them all up so they display as below
EE6 - =C6&D6&E6&F6&G6&H6&I6&J6&K6&L6&M6&N6&O6&P6&Q6&R6&S6&T6&U6&V6&W6&X6&Y6&Z6&AA6&AB6&AC6&AD6&AE6&AF6&AG6&AH6&AI6&AJ6&AK6&AL6&AM6&AN6&AO6&AP6&AQ6&AR6&AS6&AT6&AU6&AV6&AW6&AX6&AY6&AZ6&BA6&BB6&BC6&BD6&BE6&BF6&BG6&BH6&BI6&BJ6&BK6&BL6&BM6&BN6&BO6&BP6&BQ6&BR6&BS6&BT6&BU6&BV6&BW6&BX6&BY6&BZ6&CA6&CB6&CC6&CD6&CE6&CF6&CG6&CH6&CI6&CJ6&CK6&CL6&CM6&CN6&CO6&CP6&CQ6&CR6&CS6&CT6&CU6&CV6&CW6&CX6&CY6&CZ6&DA6&DB6&DC6&DD6&DE6&DF6&DG6&DH6&DI6&DJ6&DK6&DL6&DM6&DN6&DO6&DP6&DQ6&DR6&DS6&DT6&DU6&DV6&DW6&DX6&DY6&DZ6&EA6&EB6&EC6
displays - A001F001K001A002F002K002A003A005K005A019F063K063F077A089
the problem is that it no longer shows the tab symbol after each one
need it to look like (were the dots would be the tab symbol) - A001.F001.K001.A002.F002.K002.A003.A005.K005.A019.F063.
can anyone help?