I need a cell that has both a number and text to be linked to another cell and when the number in that other cell changes, the number in the cell with text also changes.

2

1 Answer

You can do this in at least two ways. Assuming that a plain number (1, for example) is in cell A1:

• If you enter =A1 & " My text" in a cell, it would take the string value "1 My text". The & operator converts the number to a string, and concatenates it to the text in the formula.
• If you enter =A1 in a cell, it will have the same numeric value as cell A1. However, you can then add a custom number format to make text appear in the same cell. Go to Format Cells / Number / Custom, then enter a format string like # "My text".

In both cases, the cell will show 1 My text, but in the second case, you can still treat it as a number, and use its value in calculations.