Forum Discussion

Copper Contributor

Apr 30, 2020

Solved

Extract a string from a "properties" field

Hello Excel experts I'm struggling with an 'extract' type of problem. Basically I need to extract a string of unknown length from a properties field. The string may or may not be present...

excel

Excel on Mac

Formulas and Functions

Detlef_Lewin
Apr 30, 2020
davidwabel
A quick solution with PQ.

techcommunity_1348412_M60645.xlsm20 KB

davidwabel

Copper Contributor

Apr 30, 2020

Detlef_Lewin

I think you mean Power Query? Is this available on Mac Excel 2016 ?

-d

Detlef_Lewin

Silver Contributor

Apr 30, 2020

davidwabel

No, PQ for Excel on Mac is still in development.

davidwabel
Copper Contributor
Apr 30, 2020
Detlef_Lewin

Thanks

Any other method ?

-d
- Detlef_Lewin
  Silver Contributor
  Apr 30, 2020
  davidwabel
  The next best thing would be VBA. But that is not my expertise.