I have an excel sheet including thousands of codes. Please see the image below.
I want to make a new code using this code. The new code should include the first 5 characters, a dash (-) and the last five characters of the current code.
Eg:25500-25789
Can someone tell me an easy way to do this instead copy paste and edit?
I will give you a way to make the new code using some options in Microsoft excel.
Type the following formula in cell C2 in the same example that you have given.
=LEFT(B2,5)
Then copy it down to other cells.
In column D2 type the following formula.
=RIGHT(B2,5)
Then copy the same formula to below the cells.
Now in the next column in cell E2 type this formula.
=C2&"-"&D2
Again copy that formula to below the cells. Then you will be able to get the result that you expected.
I believe this answer would help you in order to make easier your work.
