How to split column in Power Query by the first space?

Question

I am using Power Query and have a column called Full name, I want to split this column to a first name and last name how to do that using power query Editor in Power BI desktop

Answer 1

In Power BI, you can use split by a delimiter to split a string based on a particular delimiter as the following:

1. Click on "Edit Queries" to access the Power Query Editor.

2. Right-click on the header of the column > Select split column - By delimiter
   

3. Select space delimiter > choose each occurrence of the delimiter > click OK