Power Query : Remove String Name After Mark Comma (,)

[muhammad susanto]

hi all..

how to make this name like this

Name	Expected Result
Hin Kahn Nasution, S.H	Hin Kahn Nasution
Jadwall Firmansyah, S.E.	Jadwall Firmansyah
Visca Bafaria, S.H., M.H.	Visca Bafaria
Agus Eko Margu Jack	Agus Eko Margu Jack
Thomas Mas Janto, S.M.	Thomas Mas Janto

i want using power query, remove string after mark comma (,)

thank in advance
susant

 

[Skovgaard]

hi all..

how to make this name like this

Name	Expected Result
Hin Kahn Nasution, S.H	Hin Kahn Nasution
Jadwall Firmansyah, S.E.	Jadwall Firmansyah
Visca Bafaria, S.H., M.H.	Visca Bafaria
Agus Eko Margu Jack	Agus Eko Margu Jack
Thomas Mas Janto, S.M.	Thomas Mas Janto

i want using power query, remove string after mark comma (,)

thank in advance
susant

You can split Column by delimiter, see below.

This is the result i got:

/Skovgaard

 

[muhammad susanto]

Hi Skovgaard, thank you so much.. That, s i want

 

[Skovgaard]

Hi Skovgaard, thank you so much.. That, s i want

You're welcome

/Skovgaard