Forum Discussion

RMJ's avatar
RMJ
New Member
8 years ago
Solved

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!