split name surname in separate column

Hi Anonymous ,

This is my data:

You can create two calculated column:

_name = LEFT([Name],FIND(" ",[Name])-1)

 

surname =

VAR NAME1 = RIGHT([Name],LEN([Name])-FIND(" ",[Name]))

VAR NAME2 = RIGHT(NAME1,LEN(NAME1)-FIND(" ",NAME1))

return NAME2

 

 

Hope my answer could help you!

Ganger

Hi, on Power query right click on the column, split by delimiter and then choose "Left-most delimiter". KLL

Ciao 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.

Otherwise you can use the macro Text before and after Delimiter from here

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.