
FA Inspector (AOI) Scanner
163 | Page
FocalSpot, Inc. | www.FocalSpot.com
Concatenate [&]
Cell items can be joined into a single cell item. Example: Joining a “RefID +
Package” to form a unique “Part Number”. This would only be done if no Part
Numbers exist for this required column of data.
You can also use the ampersand (&) calculation operator instead of the
CONCATENATE function to join text items.
Example: “=A1&B1” is the same as “= CONCATENATE (A1, B1)”.
Concatenate Example
<Copy> and <Paste Special> the values into the first cell of the equation
and then delete the now unused areas.
Find & Remove
(all spaces)
Because spaces are not permitted in any CXF columnar data, with the
exception of the “Extension” field. If you receive an error when importing XY
into the AOI software, this could be as a result of spaces.
Remove all spaces by performing the following steps:
Press <Ctrl>+<F> keys to open a “Find and Replace” browser.
Comentarios a estos manuales