I need to prepend field values in an Excel sheet with the required number of characters to equal 5 characters in the field, then concatenate two fields and have all of the characters show in the new field.

Example:

Field 1 | Field 2 | Show as

abc | 123 | 00abc00123

d | 5678 | 0000d05675

Ideas?