Hi Experts, I have list of items which have not full codes. I need them to convert full code. Could you please help me.
Item code column has either 3, 2, 4 & 5 digits no. but by default they should be either 6 or 7 or 8 digits code. What best formul I need to use to get that output. Item Full Code output column has the correct answers which I manually entered. I want the same way answer using the formulas Item Full Code output Give the formula for output Item Code 200990 990 200991 991 300011 11 300014 14 300104 104 520901 20901 520902 20902 500450 450 500451 451 203529 3529 203538 3538 8515959 15959 8516271 16271 8203892 3892 8203893 3893 1620224 224 1620225 225 -- Putta -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel