Need a fixed asset verification code in excel.

Asked By Levi Jeensen 10 points N/A Posted on - 08/21/2012

I did a fixed asset verification and details are in an excel sheet including the following details.

Department, Category & item.

Eg.          Department       Category              Item                      Number

                Finance                furniture              Chair                      001

I want to create and item code as follows.

FIN/FUR/CHA/001

If the above details are in four columns in excel can I make a code in the next column by using a formula.

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

• Answer Accepted: No
• Question Category: MS Excel

Answered By Geisha Nitta 0 points N/A #145531

Need a fixed asset verification code in excel.

According to the requirement of you I will be able to give you a solution using some Microsoft excel functions. I will you “ LEFT” function and the “&” option.

I will take an example in order to explain you the answer.

Please see the image below. I entered a new column to enter the new code.

Now please be good enough to type the following formula in cell E3.

Now copy that formula into below as follows. Then you will be able to see the result you want.

Please see the report below.

I believe this answer would help you.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

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