I need to take the text from a cell and add tags to it. IE <Text></Text>.
So if cell a1 reads “random text” I want the formula to out put <text>Random text</text>.
Is this possible?