AutoCAD Electrical
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
BOM IN EXCEL
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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.
Solved! Go to Solution.
Re: BOM IN EXCEL
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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.
Re: BOM IN EXCEL
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hi,
It is working. Thankyou for your support.
regards,
Rajesh.
Re: BOM IN EXCEL
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Otherwise known as "concatenate", in Excel.
Rick Yoerger
