This article illustrates how to convert formula in text format to a **real formula **to make calculations by using the **INDIRECT function** in **Excel**. The INDIRECT function helps to make a formula dynamic. We can just change the cell reference value in the text format in a specific cell that is used within the formula without changing it. Letâ€™s dive into the following example to get a clear understanding.

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

**Introduction to the INDIRECT Function in Excel**

We can use the **INDIRECT function **to get a valid **cell reference **from a **cell value **that is **stored **as a **text string**.

**Syntax**:**INDIRECT(ref_text, [a1])**

**Arguments:**

**ref_text-**This

**argument**is a

**required**one

**.**This is a

**cell reference**, supplied a

**text**that can be either in

**A1**or

**R1C1 style**.

**[a1]**â€“ This

**argument**has

**two values-**

If

**value =**

**TRUE**or

**omitted**, the

**ref_text**is in

**A1 style reference.**

**and value= FALSE**, the

**ref_text**is in

**R1C1 reference format.**

**Convert Text to Formula Using the INDIRECT Function in Excel (Step by Step Analysis)**

**Step 1: Creating a Dataset to Convert Formula to Text in Excel**

Letâ€™s say we want to **convert **a **length **from **meter **to **feet unit**. But the **formula **which **calculates **the **value **is in **text format**.

We want to **convert **the **string formula **into a **real formula **thatâ€™ll **calculate **the **unit conversion**.

**Read More:** **Excel Show Formula as Text in Another Cell (4 Easy Methods)**

**Step 2: Apply the INDIRECT Function to Convert Text to Formula in Excel**

To solve this problem, weâ€™ll use the **INDIRECT function **in this example. To do that follow the instructions below.

- In
**cell F3**, put the**cell reference**that**holds**the**value**of**length**in**meter**unit i.e.**, B3.**

- Now in
**cell G3**, write down the**following formula**.

`=3.28*INDIRECT(F3)`

In the **formula**, we used **TRUE **as the value of **Â [a1] argument** that indicates the **ref_text argument** (**B3** in** cell F3**) is in **A1 style reference. **

- Finally, press
**Enter**and the**output**is**52 ft.**

**Dynamic Formula:**The formula, we used to calculate the conversion, is

**dynamic**. Letâ€™s make some changes-

**Case 1:**If we change the**value**in**B3**, the**output**in**G3**will**adjust automatically**.

**Case 2**: In another case, we put a**length**in the**meter**unit in**cell B4.**This time we need to**put B4**as the**value**of**cell F3.**

** **

The **dynamic formula **returns the **output **as **32.8 feet.**

**Read More:** **How to Show Formula in Excel Cells Instead of Value (6 Ways)**

**Things to Remember**

- If we use the
**ref_text argument**from another**workbook**, we must keep the**workbook open**to make the**INDIRECT function**Otherwise, itâ€™ll show**#REF**!**Error**. - Using the
**INDIRECT function**can cause**speed**and**performance lagging**while working with a**large dataset**.

**Conclusion**

Now, we know how to convert a text formula into a real formula with the help of Excelâ€™s INDIRECT formula. Hopefully, it would help you to use the method more confidently. Any questions or suggestions donâ€™t forget to put them in the comment box below.