AutoCAD Electrical General

Reply
Contributor
psrajesh4u
Posts: 19
Registered: ‎08-13-2012
Message 1 of 4 (551 Views)
Accepted Solution

BOM IN EXCEL

551 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.

Valued Contributor
JMARSHALL1249
Posts: 66
Registered: ‎01-27-2011
Message 2 of 4 (547 Views)

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.

Contributor
psrajesh4u
Posts: 19
Registered: ‎08-13-2012
Message 3 of 4 (533 Views)

Re: BOM IN EXCEL

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

Hi,

 

It is working. Thankyou for your support.

 

regards,

Rajesh.

Valued Contributor
rwydesk500
Posts: 54
Registered: ‎01-13-2010
Message 4 of 4 (310 Views)

Re: BOM IN EXCEL

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

Otherwise known as "concatenate", in Excel.

Regards,

Rick Yoerger

AutoCAD Electrical 2014

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Electrical Category!

The AutoCAD Electrical forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Ask the Community