Item code generation

[Anas_Raza]

i want to develop a Mechanism if i Enter a department Name in column B then in Column A Automatic generate its equivalent code.

 

[Shrikant]

can you elaborate more on this by giving one or two examples?

 

[Anas_Raza]

I have a sheet i which i want to categorize my store items,Electric items, Mechanical items,Maintenance items.
i want to do code of every thing.
i add all items in one column of sheet. i want to give it code automatically electric item have separate code suffix or mechanical and other separate.

 

[Shrikant]

If I have understood correctly,

you have a certain items which you have categorized like Electric Item, Mechanical Item, Maintenance Items etc.


You can Extract a part of text using LEFT function

Suppose you have a list of these items in Column A, for which category is mentioned in Column B

Example
Column A(Item) Column B (Category)
Wires Electric Items
Spanner Maintenance Items
Piston Mechanical Items


then in Column C

=LEFT(B2,4)

The result would be Elec, Main, Mech respectively.

you can combine this with Item Name as well
e.g. =A2&"-"&LEFT(B2,4)

The result would be Wires-Elec and likewise.


still how you want to give code is not clear. Is it a Number or Combination of Number and Category? I have just assumed that part for you