Tagged Questions
1
vote
1answer
49 views
Finding and removing periods in Google Spreadsheet
I'm using a Google Spreadsheet and trying to create a formula to remove a period and anything that comes before it in a cell.
For example:
idontwantthis.iwantthis
I have used this in the past:
...
1
vote
1answer
2k views
Is there a way to search and replace a regular expression in Google Docs spreadsheets?
The problem is that I entered a lot of formulas like =round(x+y) into a Google Docs spreadsheet. Now I need them exported to MS Excel and the latter only accepts =round(x+y,0) as a valid format. ...
