Aug 29 2022 12:11 PM
Hello! I'm trying to have an invoice number automatically create using a cell that contains a number and a different one containing text. It needs to read VR-MONTH-COMPANY # (VR-JULY-200). Using =IF(I5>0,TEXT(A5,"VR-###"),""), I can get the VR-200 but need to put the month in the correct place between the VR and the Company # each month as data is entered. Thanks!
Aug 29 2022 12:38 PM
Hi, I believe I can do it this way
=SE(I5>0,CONCAT("VR-","cell where the month you want to appear is located";"-",A5),"")
Aug 29 2022 12:44 PM