Forum Discussion

Copper Contributor

Feb 18, 2023

VLookup with Comma Interval

Hi all, I would like to use VLookup to abstract the phone number and email based on the name given in cell B3 and subsequent column. However, in between the name, there is a comma, may I know is...

excel

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Feb 18, 2023

renjie0315 Or perhaps Power Query. Just a quick-and dirty-solution in the attached file.

renjie0315

Copper Contributor

Feb 19, 2023

Hi Riny_van_Eekelen,

I have downloaded your excel file. However, I can't find any formula or method that you have done, it's a plain file basically. Would you mind to show me where can I locate it?