Add placeholder in last section

[playinpearls]

Hi,

I've got a list of device names and I need the last section of the name to have 3 digits.

Here is a small example:

SPT-01-1
SPT-01-20
SPT-01-250

I need:

SPT-01-001
SPT-01-020
SPT-01-250

I've tried a couple formatting techniques and watched a couple tutorials on similar problems but the dashes seem to be the kicker. Whats the easiest way to work this?

 

[BobUmlas]

=LEFT(A1,FIND("{",SUBSTITUTE(A1,"-","{",2))-1)&"-"&TEXT(MID(A1,FIND("{",SUBSTITUTE(A1,"-","{",2))+1,255),"000")
fill down

 

[playinpearls]

=LEFT(A1,FIND("{",SUBSTITUTE(A1,"-","{",2))-1)&"-"&TEXT(MID(A1,FIND("{",SUBSTITUTE(A1,"-","{",2))+1,255),"000")
fill down

that is perfect. thanks!!