Append Characters

“Append Characters” is a utility for appending (adding) text (or characters) into specific positions in selected cells.

You can choose to -

A sample screen of the “Append Characters” function is shown below:

In this sample screen, we want to insert the characters “H” after the first occurrence of “123” in each cell in the selected range. See below for a sample result:

Before Append
Result
123123123 123H23123123
aaa123aaa123 aaa123H23aaa123