I am trying to make naming my files easier. I have a spreadsheet where I have.
FILE NUMBER PROJECT NAME
My boss likes to use the naming convention of:
0001_TPR_PROJECT NAME [TPR being the company name]
I am trying to use =CONCATENATE(TEXT(A1,"0000_TPR_"), B1) but because I...