I have a spreadsheet in Google Sheets; one column tracks hashtags that were used in blog posts on a website. The posts are written on the website, and then the hash tags are copied from the website and pasted onto the sheet.
The problem is that the hash tags are formatted on the website in a strange way (they cannot be input as plain text because the designer hated making things easy), so when they are copied to the clipboard, they have no spaces like this:
However, I need to format them with a space in front of the
#sex #drugs #rocknroll
Right now I'm manually inserting the spaces, but sometimes there are 20 hash tags per post, so that will be painful long-term. Is there a way to automatically insert the space in Google sheets, or using Apps Script?