• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • AutoCAD Electrical

    Reply
    Contributor
    Posts: 19
    Registered: ‎08-13-2012
    Accepted Solution

    BOM IN EXCEL

    464 Views, 3 Replies
    11-01-2012 07:53 AM

    Hi,

     

    When generating BOM to excel I get the values of Query, user & misc lines to the separate columns.  If I merge these columns i get only first coulum data.I need to get all these values in to my descriptions columns like report generated in the style of "put on drawing" ( in normal tailed format). Is it possible? if yes please reply.

     

    Regards,

    Rajesh.

    Please use plain text.
    Active Contributor
    JMARSHALL1249
    Posts: 43
    Registered: ‎01-27-2011

    Re: BOM IN EXCEL

    11-01-2012 08:32 AM in reply to: psrajesh4u

    If I've understood you proberly, try this...

     

    Lets assume Description lines 1, 2 & 3 sit within excel boxes A2, B2 & C2.

    In a spare column in row 2 type the following:-

     

    =A2&" "&B2&" "&C2 and press enter

    This will combine the descriptions into one cell, but as a formula.  Drag the bottom right corner of the cell down to generate combined descriptions for all rows of your BOM.

    Select all these new cells, Right click the selection, select 'COPY'

    in another spare column in row2, right click again and select 'Paste option 'values'

    This will now give you the combined descriptions as raw text for your BOM.

    .

    Hope this makes sense.

    Please use plain text.
    Contributor
    Posts: 19
    Registered: ‎08-13-2012

    Re: BOM IN EXCEL

    11-01-2012 08:05 PM in reply to: JMARSHALL1249

    Hi,

     

    It is working. Thankyou for your support.

     

    regards,

    Rajesh.

    Please use plain text.
    Active Contributor
    rwydesk500
    Posts: 39
    Registered: ‎01-13-2010

    Re: BOM IN EXCEL

    11-13-2012 12:14 PM in reply to: psrajesh4u

    Otherwise known as "concatenate", in Excel.

    Regards,

    Rick Yoerger
    Please use plain text.