+ Reply to Thread
Results 1 to 3 of 3

Generating product names from product attributes and formatted fractions

Hybrid View

  1. #1
    Registered User
    Join Date
    08-26-2014
    Location
    Chicagoland, IL
    MS-Off Ver
    2010
    Posts
    0

    Generating product names from product attributes and formatted fractions

    Hello,

    We have thousands of product names in our catalog that I want to error proof by concatenating multiple cells. Below is an example of a product name:
    12 x 16 x 6 Plain Box

    The numbers represent the box size (L x W x H) and are in separate cells along with the Box description. These also happen to be Attributes in our Agile/Oracle ERP system.
    It gets complicated because I need some of the names to have fractional values like below:
    12-7/8 x 16-1/2 x 6 Plain Box

    Note that I need the simplest fraction available like 1/2; not 16/32. Also note that if it is a whole number like the “6” shown above; I need it to read as 6, not 6.0 or 6-0/16.
    Just to make it more fun :-), the numbers are input in decimal form to 5 decimal places. Example: 12.87500

    I’ve had success using the concatenate command in the past; but the manipulation of the fractions is causing issues. I’m OK with “brute forcing” this by adding columns and taking it in baby steps.
    It seems like there would be other people with similar needs. Hoping this has been solved before. THANKS in advance for your help!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167
    Hello WM3,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    08-26-2014
    Location
    Chicagoland, IL
    MS-Off Ver
    2010
    Posts
    0

    Re: Generating product names from product attributes and formatted fractions

    Hello,

    I pieced this together from various forum topics plus some known commands. There are probably ways to do it in less steps; but it gets the job done for my needs.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] I'm receiving a Run-Time error 1004 while trying to delete a product from a product list.
    By redsab in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2014, 10:03 PM
  2. Replies: 2
    Last Post: 12-06-2013, 06:06 AM
  3. [SOLVED] Find Product Details in Another Sheet based on Product ID and Copy some Fields From there
    By kevalkothari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2012, 10:43 AM
  4. [SOLVED] Need Function that will find ordered product, and display the product code in a 2nd workbk
    By rollerden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2012, 08:52 AM
  5. Generating Product Numbers
    By Luigi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2005, 08:48 AM

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