Separating first and last names

[HeRoseInThree]

I have a list of names (first and last) and I'd like to separate them into 2 columns. Wait, I know how to do that, I wouldn't waste the time of this forum for something that I can Google. The issue is that the column of names is a formula from another company that I have no access to. How would I separate them?

 

[jtakw]

Hi,

You could Copy, Paste as Value, then do your separation...

 

[alansidman]

Import the list into Power Query and then do a Split Column with a delimeter of space.

 

[HeRoseInThree]

Hi,

You could Copy, Paste as Value, then do your separation...

I tried SO many things and tried to make it WAY harder than it was! THANK YOU!!!!!!

 

[jtakw]

You're quite welcome, thanks for the feedback.