Syntax
INSERT(array, index, item)
Usage examples
| Formula | INSERT(["a", "b", "c"], 1, "x") |
| Output | 1 [ 2 "a", 3 "x", 4 "b", 5 "c" 6 ] Copy |
| Formula | INSERT(["a", "b", "c"], -2, "x") |
| Output | 1 [ 2 "a", 3 "b", 4 "x", 5 "c" 6 ] Copy |
INSERT(array, index, item)
| Formula | INSERT(["a", "b", "c"], 1, "x") |
| Output | 1 [ 2 "a", 3 "x", 4 "b", 5 "c" 6 ] Copy |
| Formula | INSERT(["a", "b", "c"], -2, "x") |
| Output | 1 [ 2 "a", 3 "b", 4 "x", 5 "c" 6 ] Copy |