How to add a costant text in specific cells

[Elad G]

Hi,
I`m looking for a formula or a code so I can a constant text to the begining and the and of the text that I have in cime cells.

Ex: I have this text on the cell: [latex](4a-5)(9a-8x)=?[latex] (and other exrecises)

and I want it to look like that in the and of the day: \begin{align}(4a-5)(9a-8x)=?\end{align}



Thanks!

[alansidman]

Please read the yellow banner at the top of this thread.

[KOKOSEK]

	A	B
1	[latex](4a-5)(9a-8x)=?[latex]	\begin{align}(4a-5)(9a-8x)=?\end{align}
2	[latex](17a+98)(13a+47x)=?[latex]	\begin{align}(17a+98)(13a+47x)=?\end{align}

	A	B
1	[latex](4a-5)(9a-8x)=?[latex]	="\begin{align}"&MID(A1,FIND("(",A1),FIND("?",A1)-FIND("(",A1)+1)&"\end{align}"
2	[latex](17a+98)(13a+47x)=?[latex]	="\begin{align}"&MID(A2,FIND("(",A2),FIND("?",A2)-FIND("(",A2)+1)&"\end{align}"