Hi everyone,
I am a PhD students and I am have a rather big excel file (25000 lines) with text cells that contain multiple hashtags and mentions. I am using excel for mac. I have my text in column A and want to extract the hashtags in column B and mentions in column C for each line. However, I am not sure how to approach the macro? Could you please help?
Thank you and all the best,
Alex
For a start attach a small sample with your expected results as per the yellow banner. It will be easier to advise from there
Hello,
Unfortunately, I cannot yet post any pictures or links or the AT sign due to my recent signup for this website. However, I want it to look something like this:
Column A
Hi i need some help with #excel #help AThelpexcel
Column B
#excel #help
Column C
AThelpexcel
Last edited by alexM123; 09-23-2020 at 05:33 AM.
Hi
Assumed you data start at "A!"
Try:
HTML Code:
Last edited by mohadin; 09-23-2020 at 01:56 PM.
Originally Posted by alexM123
You can not use CreateObject function in Mac.
Please Login or Register to view this content.
OOPs
I forget about MAC issue
Sorry
And Thank you Mr. jindon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks