I've taken forever developing this formula that you guys can probably come up with in 2 minutes. Here it is:
=RIGHT("000"&F2,6)&"/"&"501-"&RIGHT(D2,4)
What it does is create a combined string using the first two columns. The string has to be in this format ######/501-#### but as you can see in the last one the JOB # has a 0 in the end and the COMBINED STRING formula messes up.
JOB #_______FUND____COMBINED STRING
501.9071_____3017____003017/501-9071
501.0637______001____000001/501-0637
501.0637______770____000770/501-0637
501.0690______001____000001/501-.069
Please help!!
=RIGHT("000"&F2,6)&"/"&"501-"&RIGHT(D2,4)
What it does is create a combined string using the first two columns. The string has to be in this format ######/501-#### but as you can see in the last one the JOB # has a 0 in the end and the COMBINED STRING formula messes up.
JOB #_______FUND____COMBINED STRING
501.9071_____3017____003017/501-9071
501.0637______001____000001/501-0637
501.0637______770____000770/501-0637
501.0690______001____000001/501-.069
Please help!!
Last edited: