Maybe Component should be changed to Spreadsheet, because the problem is more simply visible when editing Basic macro code. It is common to want to insert spaces at the start of every line in a range (e.g. to "indent" the code one level), and replacing ^ with spaces does not work.
Maybe Component should be changed to Spreadsheet, because the problem is more simply visible when editing Basic macro code. It is common to want to insert spaces at the start of every line in a range (e.g. to "indent" the code one level), and replacing ^ with spaces does not work.