Concatenate when converting CUSIP

CUSIP exists in three varieties
CUSIP 6 = Company (issuer)

CUSIP 8 = CUSIP 6 + issue (a CUSIP 8 always refers to one CUSIP 6, but CUSIP 6 can have more than one CUSIP 8)

CUSIP 9 = CUSIP 8 + check digit
Many databases need the CUSIP 9, but many databases use other CUSIPS

Conversions are inevitable.

The following Excel formulas could be useful:

Combining cells with CONCATENATE

Concatenate cells (in Dutch samenvoegen)

=CONCATENATE(A1," ", B1)

Dutch Excel

TEKST.SAMENVOEGEN

=TEKST.SAMENVOEGEN(A1,"",B1)

Same effect, other formula:

Given a table with two data columns

=A1&B1

e.g.

The formula is visible after the ƒx symbol and has to be filled in in Cell C1
With a space between the data:

=A1&" "&B1&"

NOTE: if this formula doesn't work because your opened file conflicts with Excel, try to download your output in Excel format and repair your company identifiers afterwards by adding the lost zeros. See this blog item