split column using a word as delimiter

[RMJ]

Hi all,

I need to split the "Project_Personnel" column by investigator (see below).  Would be great to have each member of the project team in a different column. Unfortunately my excel file includes all members of the team in a single cell. I tried to use the word "investigator" as a delimiter but it did not work. Any ideas??

Thanks in advance!

[v-shex-msft]

Hi @RMJ,

I think split column feature in power query will suitable for your requirement:

Advanced Column Splitting in Power Query

Regards,

Xiaoxin Sheng

[RMJ · Accepted solution]

Problem solved! Thank you guys!