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.

When using text functions such as LEFT, MID, or RIGHT in Excel, first clean your data using the TRIM function to remove any leading or trailing spaces. For inner text spaces, consider the ...