.PL63 .PN1 L.....T.T.........................................R..L...............A .FO3 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@ [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[ UNOTE 48‰ Page # of 1 Ref: UNOTE 48~ From‰ :‰ Customer Services~ 18 Oct 89~ Re‰ :‰ String Concatenation In Spreadsheets~ AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@ [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[ L.......T.......T.......T.......T.......T.......T.......T.......T....R Here is a little known feature of the spreadsheet that seems not to be documented elsewhere. Should a user wish to join or concatenate strings within a spreadsheet cell he may do so by using a "&". As a simple example, consider the@@ A following:~ ........L........c..........c...........T.......T.......T.......T....R ‰ A‰ B~@@ A A DAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@ [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[ .....L..T.......................a.......T.......T.......T.......T....R 1‰BWarehouse Code‰ HH~@@ A [ 2‰BProduct Type‰ MC~@@ A [ 3‰BManufacturer‰ IBM~@@ A [ 4‰BMachine‰ OA~@@ A [ 5‰BModule‰ A~@@ A [ 6‰BMedia‰ C~@@ A [ 7‰B@@ A [ .....L..T...............T...............T.......T.......T.......T....R 8‰@Part Number‰ HHMCIBMOAAC~@@ A [ L.......T.......T.......T.......T.......T.......T.......T.......T....R To build up the part number shown at B8 this cell should contain the@@ AA formula:~ .UP20 ‰ = B1 & B2 & B3 & B4 & B5 & B6~@@ AAAAAAAAAAAAAAAAAAAAAAAAAAAAA .UP21 Note that all the cells contain only strings (no numbers). Should one of the cells contain numeric information, the @str() command or any@@ AAAAAA other command that returns a string, would be required to convert it to a string. Extending the example above: ........L........c..........c...........T.......T.......T.......T....R ‰ A‰ B~@@ A A DAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@ [[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[ .....L.vT.......................a.......T.......T.......T.......T....R 1‰BWarehouse Code‰ HH~@@ A [ 2‰BProduct Type‰ MC~@@ A [ 3‰BManufacturer‰ IBM~@@ A [ 4‰BMachine‰ 12~@@ A [ 5‰BModule‰ A~@@ A [ 6‰BMedia‰ C~@@ A [ 7‰B@@ A [ .....L.vT...............T...............T.......T.......T.......T....R 8‰@Part Number‰ HHMCIBM12AC~@@ A [ L.......T.......T.......T.......T.......T.......T.......T.......T....R Would require the formula at B8 to be:~@@ AA .UP 2 0 ‰ = B1 & B2 & B3 & fix(B4,0) & B5 & B6~@@ AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA .UP 2 1 Without the @fix() command the error E_TYPE would be displayed. @fix()@@ AAAAAA AAAAAA AAAAAA ensures that no decimal places are inserted into the value for B4, it@@ AA also returns a string and hence @str() is not required.@@ AAAAAA Strings may be defined as part of the formula, for example the above could be achieved by placing the following in cell A8:~@@ AA .UP20 ‰ = "Part Number " & B1 & B2 & B3 & fix(B4,0) & B5 & B6~@@ AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA .UP21 No obvious limits apply to the number of "&"'s allowed in a cell, up@@ A to the 256 character limit to any cells contents.