Converting Concatenated Fields into Text

LibreOfficeI 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.