INSERT (function)

The INSERT command allows you to insert a substring into an existing string, at a specific position that you specify. INSERT inserts the character string string (first argument) into the character string alt (second argument) starting at the position pos (third argument), whereby the counting starts with 1. The resulting character string is as long as the sum of the two individual character strings.

You can use INSERT to join strings more precisely than simple concatenation with the + symbol. You can insert spaces, special characters, or other elements to format strings to your liking. You can correct typos, add or remove text precisely. You can build complex strings by combining static and variable parts.

The position pos you specify must be an integer between 1 and the length of the main string plus 1. INSERT creates a copy of the final string.

EXAMPLE

 c$=INSERT(a$,b$,9)

Used in:
USING INSERT FUNCTION