Add characters

Modified on Wed, 19 Oct 2022 at 06:41 PM

With the Power-user add-in you can easily add custom characters within existing strings of text. This feature makes it very simple and can replace the more complex alternatives of combining all the Excel text functions to achieve the desired result.


The Add characters feature can add strings to your text in different ways:

  • Add a specific character, or add a variable range. For instance, you can add the content of column B at a specific position within the text of column A.
  • Add before or after a specific position or delimiter, which can be:
    • Before or after a specific number of characters (ex: after the 3rd character in each cell of your data source)
    • Before or after a specific number of words (ex: after the 2nd word in each cell of your data source)
    • Before or after the first occurence of a specific character (ex: after the first ocurrence of the "@" symbol)
    • Before or after every occurence of a specific character (ex: add "MUSK" after every occurence of "Elon" in the data source)
  • You can also choose to add this text as values or as formulas, in case you need to update the source data for instance.

Power-user add-in l Add characters to Excel range at specific position



See also: Remove characters

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article