Hello,
I have tried to find a solution online but no luck.
I have a list of text strings as follow:
Is there an Excel formula that allows me to get all numerical IDs at the end of each text string after the dash/hyphen?
Basically I need to extract:
10046401301
1010278462396774
1011157635563467
....
which are the Facebook pages IDs. In a nutshell it needs to extract all numeric digits before the first dash starting from the right.
Please note that sometime the trailing slash at the end is not present.
Thanks for any help