If instead you want to keep the original range, then double-click the cell and copy the text out of it, then paste it into a new ce
Time-saving tip: Once you insert the formula, you can select the cell, copy it, and paste to to a new row, an the cell range will automatically shift to the correct row.
