**Cas [back-up]** @cassolotl@queer.party · Feb 13, 2019, 22:40

**Cas [back-up]** @cassolotl@queer.party · Feb 13, 2019, 22:40

Cas [back-up] @cassolotl@queer.party

Google Sheets nerds, does anyone know how I can get this formula to work with cells that contain apostrophes? :S

**Sam the Octopus** @troubleMoney@computerfairi.es · 2019-02-13T22:55:19Z

Sam the Octopus @troubleMoney@computerfairi.es

@cassolotl try ""&A2&""

that's two speech marks before and after

**Cas [back-up]** @cassolotl@queer.party · Feb 13, 2019, 23:01

**Cas [back-up]** @cassolotl@queer.party · Feb 13, 2019, 23:01

Cas [back-up] @cassolotl@queer.party

@troubleMoney I tried that and it didn't work, but THREE before and after did work!

**Sam the Octopus** @troubleMoney@computerfairi.es · Feb 13, 2019, 23:06

**Sam the Octopus** @troubleMoney@computerfairi.es · Feb 13, 2019, 23:06

Sam the Octopus @troubleMoney@computerfairi.es

escaping characters is hard!

**Cas [back-up]** @cassolotl@queer.party · Feb 13, 2019, 23:18

**Cas [back-up]** @cassolotl@queer.party · Feb 13, 2019, 23:18

Cas [back-up] @cassolotl@queer.party

@troubleMoney Agree to both! :D