Can someone help me to create a code in excel?

Asked By 0 points N/A Posted on -
qa-featured

I have an excel sheet including thousands of codes. Please see the image below.

MS Excel make new code using old code

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?

SHARE
Answered By 0 points N/A #145397

Can someone help me to create a code in excel?

qa-featured

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)

Cosed in Excel

Then copy it down to other cells.

In column D2 type the following formula.

=RIGHT(B2,5)

MS Excel Home

Then copy the same formula to below the cells.

Now in the next column in cell E2 type this formula.

=C2&"-"&D2

MS Excel Document

Again copy that formula to below the cells. Then you will be able to get the result that you expected.

Getting Result

I believe this answer would help you in order to make easier your work.

Login/Register to Answer

Related Questions