Converting Concatenated Fields into Text
I recently created a spreadsheet of 5000 usernames by concatenating first_name with last_name. I needed to edit the text, which meant converting the calculated field into a text field. This article describes the procedure for achieving this.
Export to CSV
By exporting the .ods file as a .csv file, all the formulas are rendered out. You can then simply copy and paste the required columns from the .csv file into the .ods file.
Thanks for visiting.