Q. Is there a way to include both a formula and text in the same cell? A. You can include both a formula and text in the same cell in Excel. You can do this in many ways, depending on what you are ...

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.