The first formula worked fine. When adding the text ''Order '' (rearranged to accommodate new layout) in front each of the second option us a message returns an error. If I strip away the text "Order ", from the formula it works fine. Any ideas why this happens this way and what may be needed to fix it?
Also, when I used the code tabs the error message in MrExcel stated the tag has to be at least 3 characters long. It did however show the tags working in the preview but not once the "Submit New Thread" was clicked.
=IF(B3="",CONCATENATE(C3," - ",TEXT(TODAY(),"mmd")),IF(C3="",CONCATENATE(B3," - ",TEXT(TODAY(),"mmd")),IF(B3=C3,CONCATENATE(B3," - ",TEXT(TODAY(),"mmd")),CONCATENATE(B3," - ",C3," - ",TEXT(TODAY(),"mmd")))))
=IF(B2="",CONCATENATE("Order ",A2," ",C2," - ",TEXT(TODAY(),"mmd")),IF(C2="",CONCATENATE("Order ",A2," ",B2," - ",TEXT(TODAY(),"mmd")),IF(B2=C2,CONCATENATE("Order ",A2," ",B2," - ",TEXT(TODAY(),"mmd")),CONCATENATE("Order ",A2," ",B2," ~ ",C2," - ",TEXT(TODAY(),"mmd")))))
Also, when I used the code tabs the error message in MrExcel stated the tag has to be at least 3 characters long. It did however show the tags working in the preview but not once the "Submit New Thread" was clicked.
=IF(B3="",CONCATENATE(C3," - ",TEXT(TODAY(),"mmd")),IF(C3="",CONCATENATE(B3," - ",TEXT(TODAY(),"mmd")),IF(B3=C3,CONCATENATE(B3," - ",TEXT(TODAY(),"mmd")),CONCATENATE(B3," - ",C3," - ",TEXT(TODAY(),"mmd")))))
=IF(B2="",CONCATENATE("Order ",A2," ",C2," - ",TEXT(TODAY(),"mmd")),IF(C2="",CONCATENATE("Order ",A2," ",B2," - ",TEXT(TODAY(),"mmd")),IF(B2=C2,CONCATENATE("Order ",A2," ",B2," - ",TEXT(TODAY(),"mmd")),CONCATENATE("Order ",A2," ",B2," ~ ",C2," - ",TEXT(TODAY(),"mmd")))))