Forum Discussion
split name surname in separate column
Hi, I went to the forum, but I have not found anything that suits my case. I have a colum like this ( name and surname) MARCO DI BENEDETTO MICHELE DE ROBERTO I'd like to split into 2 separate col...
mangaus1111
Solution Sage
Solution SageCiao Diego,
you can use this in Power Query:
For Surname
= Table.AddColumn(#"Inserted Text Length", "Text After Delimiter", each Text.AfterDelimiter([Name], " "), type text)
For Name
= Table.AddColumn(#"Removed Columns", "Text Before Delimiter", each Text.BeforeDelimiter([Name], " "), type text)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.