Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you link multiple properties into one column on a BOM? 1

Status
Not open for further replies.

SWUSER71

Marine/Ocean
Aug 10, 2010
22
0
0
US
I want to link multiple custom properites to one column on a BOM. Does anyone know how to do this?
I wan to take 2 custom properties
Description
Size

and show them in the same column as
Plate - 1/2" THK
 
Replies continue below

Recommended for you

SWUSER71,

You can construct text strings in Excel consisting of elements of the other cells. Note the ampersands connecting each element in the cell.

Cell B2=3.14159265897
Cell B3="M2.5x0.7"
Cell B1="SCREW "&B3&" LONG X "&B3

Resulting cell B1...

SCREW 3.14159265897 LONG X M2.5x0.7

Critter.gif
JHG
 
Status
Not open for further replies.
Back
Top