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.
Solved! Go to Solution.
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.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.
The AutoCAD Electrical forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.
Upgrading to a 2015 product? Make sure to check these out 1st!