Good Morning,

I am working with a rather large data set and I need to take extract a portion of a cell and add something else to it.

In the "G" column of my data I have a number that looks like this

261209-002 From this number I need to extract the first 3 characters. in this case "261". I then need to add a zero (always a zero) and a hyphen in the middle. so from the above example It will read 26-10 when I'm finished.