There are mainly two ways to remove the formula in Excel and keep the text ... Then, press Ctrl+C to copy the data, including formulas. Next, keep the data range selected and right-click ...

If you try to use Excel's merge function on two columns, you'll get a warning message that merging two cells will only keep the data from the ... value so that you can remove any unneeded columns.