To remove formula in Excel and keep text using the keyboard shortcut, follow these steps: Open the spreadsheet on your computer. Use your mouse to select all cells or a range.

You could add the TRUE argument to RANDARRAY() but because we’re pulling text, it won’t matter. Let’s work through the example shown in Figure C , where the input value in D2 is 6.