How to Add the Same Text or Characters in a Range of Cells in Excel 365?
Tags: addthesametextorchar, kutoolsexceltutorial, kutools
Published: 2020-11-17 10:55:31

---
title: How to Add the Same Text or Characters in a Range of Cells in Excel 365?
published: true
date: 2020-11-17 09:24:43 UTC
tags: AddtheSameTextorChar,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-add-the-same-text-or-characters-in-a-range-of-cells-in-excel-365/
---

In this post, we will explore how to **Add the Same Text or Characters in a Range of Cells in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Add Same Text/Characters to the Beginning of Cells:

If you want to add the same text to the beginning of cells (before the first character) in Excel, then follow the below steps.

- You need to **select the range** that you want to insert the same text.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-24.png)<figcaption id="caption-attachment-17461">Select the range</figcaption>

- On the **Kutools Tab, select** the **Text** option, **choose** the **Add Text** option.

![Select the Add Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Add-Text-option.png)<figcaption id="caption-attachment-17463">Select the Add Text option</figcaption>

- It will display the **Add Text Dialog Box**.
- **Text box –** You need to **enter the text** that you want to add.
- Position – You need to **check** the **Before first character**  option.
- You can see the preview result in the **Preview pane.**

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-OK-button-10.png)<figcaption id="caption-attachment-17465">Click the OK button</figcaption>

- Then, **click** the **OK** button to get the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Output-10.png)<figcaption id="caption-attachment-17466">Output</figcaption>

## Insert Same Text/Characters at the End of Cells:

To insert the same text at the end of cells in the spreadsheet, do as follows.

- First, you need to **select the range** that you want to insert the same text after the last character of the text string.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-23.png)<figcaption id="caption-attachment-17467">Input Range</figcaption>

- On the **Kutools Tab, select** the **Text** option, **choose** the **Add Text** option.

![Select the Add Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Add-Text-option.png)<figcaption id="caption-attachment-17463">Select the Add Text option</figcaption>

- It will display the **Add Text Dialog Box**.
- **Text box –** In this box, you need to **enter the text** that you want to add.
- **Position –** In this section, you need to **select** the **After last character** option.
- You can see the result in the **Preview pane.**

![Add Text Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-23.png)<figcaption id="caption-attachment-17468">Add Text Dialog Box</figcaption>

- Finally, **hit** the **OK** button to get the output as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-17.png)<figcaption id="caption-attachment-17469">Result</figcaption>

## Add Same Text/Characters Between Existing Text String:

Here are the steps to add the same text/characters between existing text strings in Excel. Follow the below instructions.

- First, you need to **select the input range**.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-19.png)<figcaption id="caption-attachment-17471">Input Range</figcaption>

- On the **Kutools Tab, select** the **Text** option, **choose** the **Add Text** option.

![Select the Add Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Add-Text-option.png)<figcaption id="caption-attachment-17463">Select the Add Text option</figcaption>

- It will display the **Add Text Dialog Box**.
- **Text –** You need to **enter the text or characters** that you want to add.
- **Position –** You need to **check** the **Specify** option and **select the position** using the drop-down list (here, we want to insert the text after the **5<sup>th</sup>** character of the input text string).
- Then, you can see the results in the **Preview pane**.

![Add Text Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-15.png)<figcaption id="caption-attachment-17474">Add Text Dialog Box</figcaption>

- At last, **click** the **OK** button to get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-14.png)<figcaption id="caption-attachment-17475">Result</figcaption>

## Insert Same Text/Characters Before Every Uppercase, Lowercase, Letter, or Number:

If you want to insert the same text/characters before every uppercase, lowercase, letter, or number in the worksheet, then follow the below steps.

- You need to **select the range** that you want to add text/characters before every uppercase.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-12.png)<figcaption id="caption-attachment-17476">Select the range</figcaption>

- Go to the **Kutools Tab, select** the **Text** option, **choose** the **Add Text** option.

![Select the Add Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Add-Text-option.png)<figcaption id="caption-attachment-17463">Select the Add Text option</figcaption>

- It will display the **Add Text Dialog Box**.
- **Text box –** You can **type the text or character** that you need to add before every uppercase (We **press** the **Space button twice** to add double space into the text).
- **Position –** You need to **choose** the **Only add to** option and **select** the **Before uppercase letters** option from the drop-down list.
- Then, **click** the **OK** button to get the result.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-12.png)<figcaption id="caption-attachment-17477">Hit the OK button</figcaption>

- Now, you can see that the spaces are added before every uppercase letter in the selected range as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-9.png)<figcaption id="caption-attachment-17478">Output</figcaption>

### Note:

- You can also **check** the **Skip non-text cells** option from the **Add Text Dialog Box ** to avoid non-text cells.

## End of the Article:

In this post, you can clearly learn the steps to **Add the Same Text or Characters in a Range of Cells in Excel Office 365** using **Kutools. ** Leave your **queries/feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning! 

### Keep Reading:

- [Excel Calculate Date & Time:Add, Subtract Datetime, Time Difference, Age Calculation](https://geekexcel.com/excel-calculate-date-timeadd-subtract-datetime-time-difference-age-calculation/)
- [How to Select Multiple Items from the Drop-down Lists in Excel?](https://geekexcel.com/how-to-select-multiple-items-from-the-drop-down-lists-in-excel/)