In this article, I will show how to make an **exponent **in **Excel **text by using **7 **easy methods. You may need to do mathematical calculations when you work on an **Excel **worksheet. **Exponent **expression is a very common expression in mathematical calculations. In this article, I will show you seven effective ways to make an **exponent **in an **Excel **test. Hopefully, this will help you to increase your **Excel **skills.

**Table of Contents**hide

## Download Practice Workbook

Please download the workbook to practice yourself.

## 7 Effective Ways to Make Exponent in Excel Text

This is the dataset I am going to use in this article for every method. The database contains two columns, **B **and **C**, called **Numbers **and **Power**. I will add another column in the **D **column to show the results. Hence, follow the steps of every method one by one. Moreover, I have added the necessary illustrations for every step for your better understanding.

### 1. Use of Equation Option to Make Exponent in Excel Text

In this method, I will show you the procedure of making an **exponent **in Excel text by using the equation option. Follow the procedure step by step. For a better understanding, have a look at the images.

**Steps:**

- First, go to the
**Insert**option of your toolbar. - Then, select
**Symbols**. - After that, select
**Equation**.

- Meanwhile, in the
**Equation**tab select the structure option. - Then, select the
**ScriptÂ**option - After that, select the first option of the scripts.
- Hence, make a position of it in the
**D5Â**cell.

- Then, write down the base and the superscript.
- This command will show you the following result. It will put an
**exponent**(**1**) over the number**10**.

- Similarly, write down the results with superscripts for other values.

This is the procedure to make **exponent **in Excel text easily.

**Read More:** **How to Display Exponents in Excel (6 Simple Methods)**

### 2. Applying Excel Ink Equation

In this part, I will show you how to make an **exponent **in Excel by applying an Ink Equation. Follow the steps given below.

**Steps:**

- Go to the
**Insert**tab first. - Then, go to the
**Symbol**option and select the arrow in the equation option.

- Then, in the popup window, select the
**Ink EquationÂ**option.

- As a result, this command will show you the following window.

- Now, write down your required expression in the indicated window.
- As a result, the expression will be shown by this command. Then, select the
**InsertÂ**tab.

- Then, plot the equation in the
**D5Â**cell.

- Similarly, by using this command for every cell of the result column, you will get the
**exponent**in excel text.

This is the procedure to make an **exponent **by using the ink equation method.

**Read More: ****How to Use Exponent Symbol in Excel (4 Easy Methods)**

### 3. Making Exponent by Using Keyboard Shortcut

In this portion of this article, I will follow the rules of using the keyboard shortcut to make an **exponent **in excel. Follow the steps one by one. Take help from the images where necessary.

**Steps:**

- First, select the
**D5Â**cell. - Then, write down the base number
**10**in it.

- Then follow the following keyboard shortcut for distinct power.

**Alt + 0185** for power 1

**Alt + 0178** for power 2

**Alt + 0179 **for power 3

- By applying the first command, you will get the power of 10 is 1.

- By applying all the commands, you will get all the powers of the
**B**column in the**D**

This is how you can write **exponent **in excel by using a keyboard shortcut.

**Read More:** **How to Use Negative Exponents in Excel (3 Easy Methods)**

### 4. Inserting CHAR Function in Excel

Here, I will insert **the CHAR function** to write exponents in excel. Follow the steps and illustrations given below.

**Steps:**

- First, select the
**D5Â**cell.

- Then, copy the following formula in the selected cell.

`=CONCAT(B5,CHAR(185))`

We also usedÂ **the CONCAT functionÂ **to add the power component to the value inÂ **B5**.

- For power 1 you will use
**CHAR(185)**Similarly, for power**2**and**3**, use**CHAR(178)**and**CHAR(179)**respectively. - After applying all the commands, you will find the powers of 10, 20, 30, 40, 50, and 60.

By adopting this procedure, you will have the **exponents **in excel by using the **CHAR **function.

**Read More: ****How to Use Excel Exponential Function of Base 10 (6 Examples)**

### 5. Use of POWER Function to Make Exponent in Text

In this part, I will use **the POWER function** to make an **exponent **in Excel text. Follow the procedures described step by step given below. Hopefully, you will find interest in it.

**Steps:**

- Select the
**D5**cell first.

- Then, copy the following formula in the selected cell.

`=POWER(B5,C5)`

- After pressing
**Enter**, the command will show you the result as**10**.

- Then, copy down the formula from
**D5**to**D10** - Consequently, this command will show you the powers of the numbers in
**B**

You will find the powers as result by using **the POWER function** to make an **exponent **in Excel.

**Read More:** **How to Calculate Exponential in Excel (3 Easy Methods)**

### 6. Implementing EXP Function

In this method, I will show how to make an **exponent** in Excel text by implementing** the EXP function**. The procedure will show you how to get the **Euler-numberâ€™s **power values. Follow the steps given below.

**Steps:**

- Select the
**C5**cell first.

- Then, write down the following formula in the selected cell.

`=EXP(B5)`

- Consequently, this formula will basically show you the first exponent of
**Eulerâ€™sÂ**number.

- After that, copy down the formula from
**C5**to**C10**cell - As a result, Excel will show the
**exponent**of power mentioned in the**B**column by applying the formula.

This is how you can **exponent **in excel by using the **EXP** function.

### 7. Inserting Base Power to Make Exponent in Excel

In this portion of this article, I will show you making an **exponent **in Excel by inserting base power. Follow the following procedure serially.

**Steps:**

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

`=B5^C5`

- After pressing enter, the command will show you the result
**10**. - Then, copy down the formula to the last cell

- As a consequence, this command will show the power results of
**BÂ**column.

This is how you can **exponent **in excel text by using base power.

**Read More:** **Convert Scientific Notation to x10 to Power of 3 in Excel**

## Conclusion

In this article, I have tried to explain how to make an **exponent **in Excel text. I hope you have learned something new from this article. Now, extend your skill by following the steps of these methods. You will find such interesting blogs on our website **ExcelDemy.com**. I hope you have enjoyed the whole tutorial. If you have any queries, feel free to ask me in the comment section. Donâ€™t forget to give us your feedback.