LEFT and IF to make up to 10 characters

[horizonflame]

Hi in Column A, I have a mixture of 7 and
10 character long project numbers.

In Column B I want to reference all project numbers to a uniform 10 character format. With the 7 characters ones I want to add “/04” to them.

Can this be achieved with a LEFT and IF formula?

Thanks

 

[Gerald Higgins]

Sure, perhaps something like this

=if(len(a1)=7,"/04","")&a1

This assumes you want to add "/04" as a PREFIX.

If you want to add it as a SUFFIX, try

=a1&if(len(a1)=7,"/04","")

 

[horizonflame]

Thank you Gerald Higgins