Forum Discussion

atchesonc's avatar
atchesonc
New Member
6 years ago
Solved

Split Column

I have 1 column containing Joe Bloggs Accountant   I wish to split this into 3 columns -  1st - Joe 2nd - Bloggs 3rd - Accountant   Excel, in its Text to Columns functioanlity, allows me to sk...
Need Help
  • dethompson97's avatar
    dethompson97
    6 years ago

    You can use the Split columns by Delimiter in Power Query - see the steps below:

     

    Please mark as a solution if this helps! 

     

    Thanks!

    Dawn

     

dethompson97's avatar
dethompson97
Resolver III
6 years ago

You can use the Split columns by Delimiter in Power Query - see the steps below:

 

Please mark as a solution if this helps! 

 

Thanks!

Dawn