How to add leading zeros to split field string

  • Thread starter Thread starter CS
  • Start date Start date
C

CS

How do I add leading zeros to this?

BLDG: Mid([LOCATION],InStr([LOCATION],"-")+1)

Please help.
 
My response yesterday --
Left([YourField], InStr([YourField], "-")-1) & Right("00000" &
Mid([YourField], InStr([YourField], "-")+1, 5)
 
Back
Top