How to add leading zeros to split field string

C

CS

How do I add leading zeros to this?

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

Please help.
 
K

KARL DEWEY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

leading zeros 6
Length of Text 2
Stripping leading zeros 2
Keeping Leading Zeros; How Please ? 2
validation rule for exactly 5 digits, including leading zeros 0
Add Leading Zeros 4
Export of text field trims leading zeros 1
How to stop Excel from automatically truncating leading zeros 2

Top