覧覧覧
覧覧覧
 |
Refinate JoinCells.XLS |
|
To join reference designators across cells: Drag to select the RefDes as shown in the All_RefDes column below. Note that blank cells can be included in the selection. Click Get/Test and paste the result anywhere (shown below in yellow sorted in order of type occurrance). Select the newly pasted cell and click Apply for the Paint-Table-Format action for alignment and borders. |
|||||
|
This is an example of an Excel worksheet after joining RefDes across cells. |
|||||
| Joined All RefDes | Qty | ||||
| U1, U2, U4, U7-U15, U18, U23, U28-U36, U41, U42, X1, D3-D5, C7, C9, C13-C15, C19-C21, C34-C54, C60-C147, C150-C172, | 169 | ||||
| Total | Scratchpad columns | ||||
| Mftr. # | Places | All RefDes | |||
| BT8360-EPJD | 4 | U29-U32, | |||
| SAF82532H10-V33A | 1 | U28, | |||
| DS2172TN | 1 | U4, | |||
| FSM327 | 1 | X1, | |||
| VF540A-1 | 1 | U23, | |||
| DS2430AP | 1 | U18, | |||
| MC74HC4046AD | 2 | U1, U2, | |||
| DS1306EN | 1 | U41, | |||
| LTC1345ISW | 2 | U10, U11, | |||
| LT1134AISW | 2 | U14, U15, | |||
| LXT360LE | 4 | U33-U36, | |||
| TLC7733ID | 1 | U42, | |||
| DS34C86TM | 2 | U12, U13, | |||
| DS34C87TM | 3 | U7-U9, | |||
| 553-0121 | 1 | D5, | |||
| 553-0122 | 2 | D3, D4, | |||
| 12062R105K7B | 16 | C38-C53, | |||
| 1210Z474M500NT | 4 | C34-C37, | |||
| C0805C629J5GAC | 1 | C54, | |||
| 0603YC104KAT2A | 119 | C7, C9, C13-C15, C19-C21, C60-C147, C150-C172, | |||