Advanced Find and Replace

From Open Source Ecology
Jump to: navigation, search

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

  • Test spreadsheet shown in the video so you can try this - [1]. Note that to increase the numbers, you auto fill cells by dragging bottom right corner of first line downwards for as many cells as you like.
  • Online find and replace + carriage return text editor - http://www.unit-conversion.info/texttools/replace-text/#data