Adding Text to a Cell Without Stopping Workflow of Other Cells

Hello world,

I have a workbook that has many mathematically linked cells, and I would like to add text to some of the cells. The only method I know of doing sois adding the below at the end of the equation of the cell I want to add text to:

> &CONCATENATE("words...texts...")

Works great, except the formulas of the rest of other cells that are linked this cell (that I just added text to) stop working since they need a number input (instead of a number and some text).

Is there a way I can work around this to make the other cells still be able to calculate their respective formula?

Or is there a different way I can add text to a cell that has a formula? Is there a way to make the next cell only use part of the value of the previous cell and ignore the text?

Thank you so much guys, I'm learning so much here.

Best,
Sep

This is exactly what I need, thank you for the help!

I am a little confused though, what are you exactly typing in the cell?

I see, exactly what I need, thanks for that!