Chuda wrote:
The =TRIM() is working fine, but what I want is for it to leave me with raw
text as a result, which I can then edit.

Without using VBA (you remember doing "something really simple"), the
only way I know how to do that is:

1. Right-click the cell with =TRIM() formula and select Copy.
2. Right-click any cell (it could be the cell with =TRIM) and select
Paste Special Values

Is that what you are looking for?