Results 1 to 5 of 5

How do I make a part number formula?

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2009
    Location
    Alabama, United States
    MS-Off Ver
    Excel 2003
    Posts
    8

    How do I make a part number formula?

    I'll try to keep this brief. Our part #'s look like this. XP014567. Where the first pair of characters stand for a value(say XP=Bolt), the second pair stand for a value(01= Grade 2), and so on. What I would like to be able to do is type in the part numer and have the description automatically populate. Is there an easy way to do this ? I'm running Excel 2003. Thanks!

    Todd
    Last edited by VBA Noob; 04-23-2009 at 03:21 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1