Thread: Format

What is the formula to return a column in the format "B-NNN-00N" or "B-0NN-001" if the displayed column is either in the format "B-NN-00N", "B-NNN-N" where "N" is a number?. For example, if the column displays "B-123-1" then it has to return "B-123-001", and if it displays "B-12-001" then it has to return "B-012-001". I tried "concatenate" but did not get the right result

Hi Ashraf,

See the attached file and let me know if I understood you correctly. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Ok..

It is already done.. check the formula in column B.
Test this out and let me know if this can fit in all possible scenarios. Thanks.

Regards,
DiLIPandey

<click on below 'star' if this helps>

You are welcome ashraf...

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>