Posts by world33

Re: formula to remove all characters after a dash in a text string from the right

Thanks Carim,

I managed to refine your formula and get the ID

=SUBSTITUTE((RIGHT(A2,LEN(A2)-(SEARCH("^",SUBSTITUTE(A2,"-","^",LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))))))),"/","")

Thank you for your input.

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

Re: What function should I use?

Hello Maqbool

I received another formula

=IF(ISNUMBER(MATCH(C1,$B$1:$B$7,0)),INDEX($A$1:$A$7,MATCH(C1,$B$1:$B$7,0)),"")

It is working properly.

Thanks anyway for your time.

Cheers,

F

Re: What function should I use?

Hi Maqbool,

Thank you for your reply.
Unfortunately this is not what I am looking for. The URLs in the Col C must be copied and pasted in an existing database togheter with the associated fax. If I just get the URLs with the fax combined and exclude all other URLs in the Col C I cannot copy and paste into the existing databse. In your excel sheet there is no function in the Column D where the faxes sould be associated. Faxes are just manually copied and pasted.

Thanks anyway for your time . I appreciate it.

Fabio

Hello,

I have got three columns A, B, C.

In column A I have 7 fax numbers. In column B I have 7 URLs where faxes have been extracted from. In column C I have 14 URLs in which, among others, are included the exact URLs in column B.

I want associate faxes in column A with URLs (matched with those in column B) present in column C.

Ex.

COL A
1 1-785-227-2004
2 208-376-7743
3 (617) 912-9101
4 267-502-2658
5 (317) 940-9930
6 716-888-2525
7 (219) 473-4259

COL B
1 http://www.bethanylb.edu/
2 http://<woltlab-metacode-marker data-name="b" data-uuid="9636b74a-8397-4846-9a61-e934ac45721f" data-source="W0Jd" />www.boisebible.edu/<woltlab-metacode-marker data-uuid="9636b74a-8397-4846-9a61-e934ac45721f" data-source="Wy9CXQ==" />
3 http://www.conservatory.edu/
4 http://www.brynathyn.edu/
5 http://www.butler.edu/
6 http://<woltlab-metacode-marker data-name="b" data-uuid="83308ac2-b2f5-4947-8f9b-0a783c9281e5" data-source="W0Jd" />www.canisius.edu/<woltlab-metacode-marker data-uuid="83308ac2-b2f5-4947-8f9b-0a783c9281e5" data-source="Wy9CXQ==" />
7 http://<woltlab-metacode-marker data-name="b" data-uuid="ad133d5b-c8a4-4554-9556-fe319cc2304f" data-source="W0Jd" />www.ccsj.edu/<woltlab-metacode-marker data-uuid="ad133d5b-c8a4-4554-9556-fe319cc2304f" data-source="Wy9CXQ==" />


COL C--------------------------------------- COL D
1 http://www.ab.edu/
2 http://www.abc.edu/
3 http://www.abconline.edu/
4 http://www.ac.edu/
5 http://www.aca.edu/
6 http://www.academy.edu/
7 http://<woltlab-metacode-marker data-name="b" data-uuid="58564a6d-ab86-46ae-8b08-4f5c4fccb864" data-source="W0Jd" />www.boisebible.edu/<woltlab-metacode-marker data-uuid="58564a6d-ab86-46ae-8b08-4f5c4fccb864" data-source="Wy9CXQ==" />-----------> 208-376-7743
8 http://www.boisestate.edu/
9 http://www.brevard.edu/
10 http://<woltlab-metacode-marker data-name="b" data-uuid="54205467-ca57-4f1e-82ae-85f742c7ace6" data-source="W0Jd" />www.canisius.edu/<woltlab-metacode-marker data-uuid="54205467-ca57-4f1e-82ae-85f742c7ace6" data-source="Wy9CXQ==" />-------------> 716-888-2525
11 http://www.carleton.edu/
12 http://www.carroll.edu/
13 http://<woltlab-metacode-marker data-name="b" data-uuid="36843590-5241-40ca-b656-d668753064e8" data-source="W0Jd" />www.ccsj.edu/<woltlab-metacode-marker data-uuid="36843590-5241-40ca-b656-d668753064e8" data-source="Wy9CXQ==" />------------------> (219) 473-4259
14 http://www.clemson.edu/

Which function should I use in order to get faxes in Col A and put them next to the appropriate URLs (matched with URLs in column B) in column C :confused: ?

Thanks a lot !!

Fabio