Can someone help me to create a code in excel?

Asked By Rachel Will McDowell 0 points N/A Posted on - 08/21/2012

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?

• Status: Open
• Question Views: 867
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Geisha Nitta 0 points N/A #145397

Can someone help me to create a code in excel?

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.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/21/2012
• Question Category: MS Excel