How to insert a formula in a cell with text

[Lisa James]

How do I insert a formula in a cell that already has a text?

 

[maabadi]

Welcome To MrExcel Message Board.
Please give Example.
If you want see formula not result Use FORMULATEXT Function.
If you want Use Text within Formula Then.
Example

=If(A2="Lisa", 1000, 1)

 

[Sufiyan97]

How do I insert a formula in a cell that already has a text?

in Cell A1 if there is a text you need to write that text in = and double quotes ("") for example

A1 ="Text" and then use & to join with formula

Book3
	A	B
1	Text Lisa James	Lisa James
2	Text Lisa James	Lisa James
Sheet1

Cell Formulas
Range	Formula
A1	A1	="Text "&B1
A2	A2	="Text "&IF(B2="Lisa James",B2,"")

 

[Fluff]

Hi & welcome to MrExcel.
A cell can have a formula, or a value but not both. So not quite sure what you are after.