"MITSUBISHI FX3U-ENET-ADP" Return as MITSUBISHI

[Paulyeo11]

Hi All

May i know how to filter the first word from description ? 

For example :-

MITSUBISHI FX3U-ENET-ADP

Return as :-

MITSUBISHI

[Anonymous]

@Paulyeo11 - You can go to power Query and Under Transform tab you would find Extract as below-

there you can choose first Characters and Put 10 as value. That would give you desired result.

[Fowmy · Accepted solution]

@Paulyeo11 

You can use the Split Column or Extract option in Power Query to achieve your desired result:

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Paulyeo11]

Hi Sir

Thank you very much

Paul