Advanced Find and Replace: Difference between revisions
Jump to navigation
Jump to search
(→Source) |
|||
(One intermediate revision by the same user not shown) | |||
Line 3: | Line 3: | ||
=Procedure= | =Procedure= | ||
<html><iframe width="560" height="315" src="https://www.youtube.com/embed/xqGWjMHNVeU" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe></html> | |||
=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]. 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 | *Online find and replace + carriage return text editor - http://www.unit-conversion.info/texttools/replace-text/#data |
Latest revision as of 15:01, 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
- 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