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

     

atchesonc's avatar
atchesonc
New Member
6 years ago

Thank you

 

if i specify 2 here, would that take the full conents of the original column, i.e., Joe Bloggs Accountant, and split it over 2 columns?  What i want is to discard the word Accountant altogether.

 

Thanks

 

claire

dethompson97's avatar
dethompson97
Resolver III
6 years ago

Claire,

 

If I understand your question, if you choose "at Right most delimiter" instead of "at Each occurence" then you will get the name in one column and Accountant in the other.

 

If this solves your problem, please mark it as a solution so others can find it - Kudos are nice too!  

 

Thanks!

Dawn