In this article, we will learn how to add numbers, text, time, date, and special characters to a cell value in Excel.

We will apply the **SUM, CONCATENATE, NUMBERVALUE, CHAR, TIME, **and **TEXT **functions, Excel feature, and VBA code to add such as numbers, text, time, date, and special characters to a cell value in Excel.

Excel streamlines data management and calculations, including adding values to cells. This functionality allows users to effortlessly modify existing cell values, saving time and enhancing productivity.

**Download Practice Workbook**

Download this practice workbook for practice while you are reading this article.

## Why Do We Add Cell Values in Excel?

Adding cell values in Excel serves several important purposes and offers numerous benefits. Here are some reasons why we add cell values in Excel:

- Mathematical Calculations
- Data Analysis
- Data Summarization
- Data Manipulation and Transformation
- Updating and Tracking
- Conditional Operations
- Creating Formulas and Formatted Outputs
- Data Validation and Error Checking
- Automation and Efficiency

## How to Add a Cell Value in Excel

Here weâ€™ll learn how to add a cell value in Excel.

### 1. Use SUM Function

Now we will apply **the SUM function** to add a cell value in Excel. Letâ€™s follow the instructions below to learn!

- In cell
**F12**, write down the following**SUM**function to add a cell value.

`=SUM(D5,15)`

### 2. Apply Paste Special Feature

You can also add a cell value by applying the Paste Special feature in Excel.

- Copy the value of cell
**G5**>> Select data range**D5**to**D11**>> Go to the**Home**tab >>**Clipboard**>> Choose the**Paste Special**feature from the**Paste**drop-down list.

- A
**Paste Special**dialog box pops up >> Check the**Values**option from the**Paste**group >> Select**Add**option from the**Operation**group >>**OK**.

- Finally, you will be able to add a cell value of
*15 units*to*column D.*

### 3. Use Arithmetic Operation

Now, weâ€™ll add **15 **to column **G** using an *Arithmetic Operation *named *plus(+)* symbol.

- Write down the following formula in cell
**G5**. Hence,**AutoFill**the formula.

`=D5+15`

### 4. Apply CONCATENATE Function

Enter the following **CONCATENATE **function in cell **G5 **and **AutoFill **the formula.

`=CONCATENATE(C5, " sold by ", B5,".")`

### 5. Use Flash Fill Feature

Using the Flash Fill feature, you can fill all the cells in a column based on the pattern of what you are trying to do. Here, we will show you a very easy tool to **add text** to **cell value** in **Excel** using the **Flash Fill **command.

- Write down the text in cell
**G5**that you want to**Fill >>**Go to the**Home**tab >> Choose**Editing**group >> Select**Flash Fill**feature from the**Fill**drop-down list.

- As a result, you will see the following results by adding text to the cell value for all the cells.

### 6. Run an Excel VBA Code

You can add cell values using the **VBA **macros. Letâ€™s follow the instructions below to learn!

- Select data range from
**E5**to**E11**>> Choose**Developer**tap >> Select the**Visual Basic**feature from the**Code**group.

- Hence, select
**Module**from the**Insert**tab to open a Module for inserting the below**VBA**code. - After that, run the
**VBA**code.

```
Sub Add_Cell_Value()
'Declaring Variables
Dim R As Range
Dim Mcell As Range
Set R = Application.Selection
'Declaring the Text for cell value
For Each cell In R
cell.Offset(0, 1).Value = "Total Sales of " _
& cell.Offset(0, -3).Value & " is: " & cell.Value
Next cell
End Sub
```

- Finally, you will be able to add cell values.

## How to Add Text to Cell Value in Excel

You can add text to the cell value using the **Ampersand symbol** in Excel. Letâ€™s follow the instructions below to learn!

- Type the following formula in cell
**G5**and**AutoFill**the formula.

`="Total Sales of "&B5& " is " &E5`

## How to Add Digits to a Number in Excel

Also, you can use **the NUMBERVALUE function** and **Ampersand(&) **Operator to **add digits in a Number both at the starting and ending in Excel**. Here, I will add the digits at the** end **of a number.

- Select the
**D5**cell and write down the following formula in that cell. Hence,**AutoFill**the formula.

`=NUMBERVALUE(C5&"10")`

- Finally, you will see the
**number with added digits at the ending**.

**Notes:** you can **add digits in front of a number in Excel **by using the following function.

`=NUMBERVALUE("10"&C5)`

## How to Add Special Character to Cell in Excel

Now, we will add a special character to the text. From our dataset, weâ€™ll add a ** registered symbol(Â®)** as a special character to the text.

- Insert
**the CHAR function**in cell**G5**and**AutoFill**the function to the rest of the cells in column**G**.

`=C5&CHAR(174)`

## How to Add Time in Excel

You can use **the TIME function** to add 1 hour to time in Excel. Moreover, you can easily change hours, minutes, and seconds with this function. Letâ€™s follow the instructions below to learn!

- Insert the following formula in cell
**H5**and**AutoFill**the formula.

`=D5+TIME(1,0,0)`

## How to Add Date in Excel

In this section, we will apply **the TEXT function** to add *5 days* with a date in Excel.

- Enter the below formula in cell
**H5**and**AutoFill**it.

`=TEXT(D5+5,"dd/mm/yy")`

## Things to Remember

- You can use
**Alt + F11**as keyboard shortcuts to pop up the**Microsoft Visual Basic Applications**window.

## Frequently Asked Questions

** 1. Can I add a value to a cell without using a formula?**

**Answer:** Yes, you can add a value to a cell in Excel without using a formula. By using a simple arithmetic operation, you can directly add a value to an existing cell value. Just select the cell and enter the plus symbol (+) followed by the desired value. Press Enter to calculate the result and display it in the cell.

** 2. How can I add a percentage to a cell value in Excel?**

**Answer:** To add a percentage to a cell value in Excel, you can use a formula or a simple arithmetic operation. Select the cell where you want the result to appear. Enter the formula that adds the percentage to the existing cell value. For example, if you want to add **15%** to the value in cell **B2**, you can use the formula “**=B2+(B2*0.15)**“. Press Enter to calculate the result and display it in the cell.

** 3. How can I add a value to a cell and update it automatically when the referenced cell changes in Excel?**

**Answer:** To add a value to a cell in Excel and have it update automatically when the referenced cell changes, you can use a formula that references the desired cell. Excel’s built-in cell references ensure that the value is updated whenever the referenced cell changes. For instance, if you want to add **10 **to the value in cell **A2**, you can use the formula “**=A2+10**“. If the referenced cell (**A2** in this case) is updated later, Excel automatically recalculates the formula and updates the result in the cell where you added the formula.

## Conclusion

We have learned how Excel adds numbers, text, time, date, and special characters to a cell value. I hope from now on, you can easily add a number, text, time, date, and special characters in Excel. If you have any better methods or questions or feedback regarding this article, please share them in the comment box.

## Excel Add to a Cell Value: Knowledge Hub

- Excel Add Number to Existing Cell Value
- How to Add a Number in Front of a Number in Excel
- Excel Add 1 to Each Cell in a Column
- How to Add Digits to a Number in Excel
- How to Add 2 Digits to a Number in Excel

**<< Go Back to How to Sum in Excel | How to Calculate in Excel | Learn Excel**