Using LEFT, MID, RIGHT Functions

[IMA_Saihat]

Hi,
If we have organization codes in (7) or (8) digits and we want to modify these codes to read (00-000-000), we can make the required modification in two steps.
Step (1):
We add (0) to the (7) digits by the following formula:
=IF(LEN(A2)=7;"0"&A2;A2)



Step (2):
We add two(-) to the (8) digits by the following formula:
=LEFT(B2;2)&"-"&MID(B2;3;3)&"-"&RIGHT(B2;3)