1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Hashtags and Mentions extraction from text column

    From Alex Martin@21:1/5 to All on Wed Sep 23 01:37:36 2020
    Hello,

    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 the
    texts 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?

    Thank you!

    Alex

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Mon Sep 28 17:27:32 2020
    Hi Alex,

    Am Wed, 23 Sep 2020 01:37:36 -0700 (PDT) schrieb Alex Martin:

    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 the
    texts 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?

    please post some examples.


    Regards
    Claus B.
    --
    Windows10
    Office 2016

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)