Challenge #20: List Parsing

[elaineyuan]

/what a challenge!! 💦

Spoiler

[Hammad_Rashid]

[jennifer_owens]

Wow. This took a while. I finally have it completed. I have one minor difference but I am not unhappy with it. I pull in the incorrect/abnormally long phone number for Regency Direct Marketing (I) Pvt. LTD (912224903410). Note it has too many numbers but since the fax was also incorrectly long, it seemed better than the alternative which was to leave it with the address as the final output does. 

[chandler-gjino]

Attaching my solution

[BS_THE_ANALYST]

Brute forced it. Fun challenge. Every time I thought I had the answer another nuance cropped up! 😂

Spoiler

[lucaskro]

Spoiler

[MitchellBliesner]

That challenge was rough. I definitely need more practice. Below is my solution to the challenge. 

Spoiler

[The_Rad_Valentina]

Really fun way to use RegEx Match and some Multi-Row formula tools. I don't know if my solution is similar to others, but I got there nevertheless. 

[bo_peng2022]

My solution

[OzlemSigbeku]

Spoiler