Advanced Find and Replace: Difference between revisions
Jump to navigation
Jump to search
(→Source) |
(→Source) |
||
| 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]. 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 | ||
Revision as of 14:58, 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