Forum Discussion
RMJ
8 years agoNew Member
split column using a word as delimiter
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!
Problem solved! Thank you guys!
2 Replies
- RMJNew Member
Problem solved! Thank you guys!
- AnonymousNot applicable
Hi RMJ,
I think split column feature in power query will suitable for your requirement:
Advanced Column Splitting in Power Query
Regards,
Xiaoxin Sheng