So you have a list of phrases we want to turn into hashtags. First use the hashtag after an equal sign and an ampersand, and then we want to substitute everything in A2 that is a space, and we're going to replace it with nothing, two quotes that have no space in between. That we get this hashtag life goals, and we can copy paste this all the way down, but without doing that. But we don't want to copy paste all the way down. What if we could do this all in one formula ? Surround everything with array formula and instead of A2 change it to A2 colon A. Add a parenthesis at the end and we get the entire column of every single phrase turned into a hashtag. If you're looking for more Google Sheet formula combinations like this that are going to make your life in Google Sheets better, subscribe

here to Better Sheets on YouTube.