[[https://openrefine.org/|Open Refine]] is an open source tool that allows you to clean up spreadsheets in preparation for conversion into EAD, or just general cleanup.  There is an [[https://openrefine.org/docs|extensive user manual]], but we will be collecting commands here that are most useful for our use cases.

===== Insert text at beginning or end of string =====

Select column you wish to insert text in then select **Edit cells--->Transform...**

{{:screenshot_2025-03-12_at_12.55.07_pm.png?400|}}

Beginning of string: //("text to insert")value+//

{{:screenshot_2025-03-12_at_12.56.21_pm.png?400|}}

End of string: //value+ ("text to insert")//

{{::screenshot_2025-03-12_at_12.55.57_pm.png?400|}}