I'm glad it helped. Thanks for the feedback.
--
tj


"GR" wrote:

This completely answered the challenge. Plug in and went thru hundreds of
records less than a minute with complete accuracy!

"tjtjjtjt" wrote:

This seems to be working for me:
=LEFT(A10,FIND("-",A10,1))&0&MID(A10,FIND("-",A10,1)+1,255)&"-03"
--
tj


"GR" wrote:

Have column of numbers that must be converted to a new number by simply
adding same to number is two specific places. ex: 6200-80 must become
6200-080-3

How to do this w/out re-keying entire workbook?