Let’s say you need a long series of numbers in your spreadsheet and you are trapped on a Chromebook. Yes, I could drag down to fill but this takes way too long if you have a long list of numbers.
I hate that Google Sheets cannot do what Excel can do below:
Fortunately, there is Text Mechanic– a website that provides a collection of text manipulation tools that work in your browser. I used the Generate List of Sequential Numbers tool get the series of numbers I needed.
From here, I can copy and paste my list into Google Sheets and start calculating.
Text Mechanic has some other great tools too. Take a look at Find and Replace Text and Add/Remove Line Breaks. They have been a big help.
RSS - Posts
Recent Comments