I've got some rows in Google Sheets that contain strings. I want to extract certain parts from this string and enter them into another cell:
specifically, I want to extract words/names that begin with the character "@".
For example in the string "Hello @Henry how are you" I want the next cell along to display only "@Henry", removing all the other words.
There are also cases when there are multiple names beginning with @ and I would want all of these returned (preferably in separate columns).
Can anyone help me with this?
Edit: dummy spreadsheet below: