|
RefinateHome
The Basics
Examples
Screenshots
One-row-per-part
覧覧覧
Download Refinate
Register
覧覧覧
Revision History
Support
Quick Exercises
HyphenateRanges.XLS
ExpandRanges.XLS
JoinCells.XLS
Assy Versions.XLS
Redundant_Part_Info
Netlist Sorting
Procedures:Compare
Company Info
| |
 |
|
Refinate Redundant
Part Info |
SLIDE #4
Removing Redundant Text
In the row for the first part, select all the
refdes columns used for all parts.
|
H1 |
= |
|
|
|
H |
I |
J |
K |
L |
M |
N |
O |
P |
Q |
R |
S |
|
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
CON38 |
CON38 |
MDR36_VERT_FIX |
J4 |
J5 |
J6 |
J7 |
J8 |
|
|
|
|
|
3 |
RJ-45S |
CON10 |
RJ-45S_FIX_LARGE |
J3 |
|
|
|
|
|
|
|
|
|
4 |
RJ-45S |
CON11 |
RJ-45S_FIX_LARGE |
J10 |
|
|
|
|
|
|
|
|
|
5 |
RJ-45S |
CON12 |
RJ-45S_FIX_LARGE |
J11 |
|
|
|
|
|
|
|
|
|
6 |
RJ-45S |
CON13 |
RJ-45S_FIX_LARGE |
J12 |
|
|
|
|
|
|
|
|
|
7 |
RJ-45S |
CON19 |
RJ-45S_FIX_LARGE |
J20 |
|
|
|
|
|
|
|
|
|
8 |
RJ-45S |
CON20 |
RJ-45S_FIX_LARGE |
J21 |
|
|
|
|
|
|
|
|
|
9 |
RJ-45S |
CON21 |
RJ-45S_FIX_LARGE |
J22 |
|
|
|
|
|
|
|
|
|
10 |
0.1UF |
CAPACITOR |
SM/C_0805 |
CA1 |
CA10 |
CA11 |
CA12 |
CA18 |
CA2 |
CA3 |
CA9 |
|
|
11 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
Select all of the columns used for refdes. Set the
mode to Count Ranges and choose the Paste_Format option. Then
click Auto-Paste_V to group all refdes for each
part into one cell. |
|