IF with cells containing text & numbers

New Contributor

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!Invoice Numbers sample.png

2 Replies

@Sheilveil 

 

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),"")

The formula is in Portuguese, in your case use =IF(I5>0,CONCAT("VR-","cell where the month you want to appear is located";"-",A5),"")