BOM IN EXCEL

[psrajesh4u]

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.

[JMARSHALL1249 · Accepted 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.

[psrajesh4u]

Hi,

It is working. Thankyou for your support.

regards,

Rajesh.

[rwydesk500]

Otherwise known as "concatenate", in Excel.