Advanced Find and Replace: Difference between revisions

From Open Source Ecology
Jump to navigation Jump to search
Line 6: Line 6:


=Source=
=Source=
Test spreadsheet shown in the video so you can try this - [https://docs.google.com/spreadsheets/d/1zPa8ybn146bJWEIXrdUvYvdQqooX83UvxxVEWNQI9Uw/edit#gid=0]
*Test spreadsheet shown in the video so you can try this - [https://docs.google.com/spreadsheets/d/1zPa8ybn146bJWEIXrdUvYvdQqooX83UvxxVEWNQI9Uw/edit#gid=0]
*Online find and replace + carriage return text editor - http://www.unit-conversion.info/texttools/replace-text/#data

Revision as of 14:56, 22 May 2021

Intro

It is useful to automate ordinal numbering in large lists - say 50+ lines - from manually changing small parts of text such as number - to spreadsheets and find-and-replace functionality.

Procedure

Source