- MS Excel Basics
- Excel - Home
- Excel - Getting Started
- Excel - Explore Window
- Excel - Backstage
- Excel - Entering Values
- Excel - Move Around
- Excel - Save Workbook
- Excel - Create Worksheet
- Excel - Copy Worksheet
- Excel - Hiding Worksheet
- Excel - Delete Worksheet
- Excel - Close Workbook
- Excel - Open Workbook
- Excel - Context Help

- Editing Worksheet
- Excel - Insert Data
- Excel - Select Data
- Excel - Delete Data
- Excel - Move Data
- Excel - Rows & Columns
- Excel - Copy & Paste
- Excel - Find & Replace
- Excel - Spell Check
- Excel - Zoom In-Out
- Excel - Special Symbols
- Excel - Insert Comments
- Excel - Add Text Box
- Excel - Undo Changes

- Formatting Cells
- Excel - Setting Cell Type
- Excel - Setting Fonts
- Excel - Text Decoration
- Excel - Rotate Cells
- Excel - Setting Colors
- Excel - Text Alignments
- Excel - Merge & Wrap
- Excel - Borders and Shades
- Excel - Apply Formatting

- Formatting Worksheets
- Excel - Sheet Options
- Excel - Adjust Margins
- Excel - Page Orientation
- Excel - Header and Footer
- Excel - Insert Page Breaks
- Excel - Set Background
- Excel - Freeze Panes
- Excel - Conditional Format

- Working with Formula
- Excel - Creating Formulas
- Excel - Copying Formulas
- Excel - Formula Reference
- Excel - Using Functions
- Excel - Builtin Functions

- Advanced Operations
- Excel - Data Filtering
- Excel - Data Sorting
- Excel - Using Ranges
- Excel - Data Validation
- Excel - Using Styles
- Excel - Using Themes
- Excel - Using Templates
- Excel - Using Macros
- Excel - Adding Graphics
- Excel - Cross Referencing
- Excel - Printing Worksheets
- Excel - Email Workbooks
- Excel- Translate Worksheet
- Excel - Workbook Security
- Excel - Data Tables
- Excel - Pivot Tables
- Excel - Simple Charts
- Excel - Pivot Charts
- Excel - Keyboard Shortcuts

- MS Excel Resources
- Excel - Quick Guide
- Excel - Useful Resources
- Excel - Discussion

# How to Add Text at the Beginning or End of All Cells in Excel?

Let's suppose you need to add a particular text string in all the cells of an Excel sheet at the beginning or end of the existing data. It can be a tedious process if you decide to perform this such a task manually. In this tutorial, we will show you a simple method by which you can do it using a formula in Excel.

We can add text in beginning or end using the same formula but the process is sequence of the work is different. Let us see the simple process to add text in bigging or end of all cells

## How to Add Text to the Beginning of All Cells in Excel?

We will essentially use the same formula to add text at the beginning or end of selected cells, but the process is slightly different for both.

For adding text at the beginning of a cell, we will use the formula −

= "data" & address of data

For adding text at the end of a cell, we will use the formula −

= address of data & "data"

Let's take an example and see how it is implemented.

### Step 1

Open an Excel sheet and insert some dummy data in a column, as shown below −

### Step 2

Select a cell where you want to display the first result and then type the formula **="data"&A2 ** in the formula box. Here, we are adding the text "data" at the beginning of the cell.

Press the "Enter" button to get the first result.

### Step 3

You have successfully updated the first item. Similarly, you can update all the data values just by dragging down from the right corner of the cell where the first result is displayed. The final screen will appear like the one shown below −

## How to Add Text at the End of All Cells in Excel?

We successfully added data before the text now let us the process to add the data after provided data

### Step 1

For adding the text after the number let us consider the same data which we used in the above example

type the formula as **=A2&"data" **in the formula box after clicking on the cell where we want to create our result

Click enter to get our first result as shown in the below figure −

### Step 2

We have successfully created the result for the first item we create results for all the remaining data just by dragging down from the right corner of the cell where the result is already present and our final result will look like the below image −

This is how we can add text at end of the data for all the cells in excel

**Tip **− In the formula, the data that is to be added must be present inside the double quotes

## Conclusion

In this tutorial, we used a simple example to demonstrate how you can add text at the beginning or end of all cells in Excel.

- Related Articles
- How to add comma at the end of cell/text in Excel?
- How to Add Text in the Middle of Selected Cells in Excel?
- Add elements at beginning and end of LinkedList in Java
- How To Add Text Cells Together Into One Cell In Excel?
- How to add all borders to cells with shortcuts in Excel
- How to Add Prefix or Suffix to a Range of Cells in Excel
- How to insert text at the beginning of the text box in Tkinter?
- How to Add Quotes around Numbers or Text in Excel
- How to Add or Pad Leading Zeros to Numbers or Text in Excel?
- How to Add Units to Cells in Excel?
- How to match text at the start or end of a string in Python?
- How to add borders automatically to cells in Excel?
- How to Add Periods to The End of Cell Contents in Excel?
- How to center text across multiple cells in Excel?
- How to Convert HTML to Text in Cells in Excel?