Google Workspace users have the option to publicly share files or folders stored in Google Drive. How to share a Google Drive folder publicly.Now you can enter signs in any cell without starting a formula or function. For example: '+word+word will come out as just +word+word. This tells Google Sheets that you are trying to enter plain text and not a formula. However, there’s an easy workaround so you can add the + sign in a cell followed by plain text.īefore you enter the plus sign, start with a single apostrophe in the cell. When you try to enter a phone number in Google Sheets or anything that starts with the plus sign, the cell will automatically create a formula. Stop the plus sign from generating a formula in Sheets.