I am currently experiencing a slight issue in my attempt to extract hashtags and mentions in my excel file. I have roughly 25 000 lines and I want to extract all the hashtags (there could be several within one cell) and all the mentions. I have all thetexts in column A and I want the hashtags in column B and mentions in column C. However, I am unsure how to proceed and get this to work. Anyone of you that could help me with this? Perhaps with a good macro?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 292 |
Nodes: | 16 (2 / 14) |
Uptime: | 200:08:50 |
Calls: | 6,617 |
Calls today: | 1 |
Files: | 12,168 |
Messages: | 5,316,118 |