Split cell with multiple spaces
Hi
I am trying split a column of cells into two columns, however my data does not have specific delimiters. ie
Joe Blogs DeptA xxxx
Ian Smart DeptB xyxy
I need to split into 2 cells after the name and before the Dept
Any pointers would be welcome
Thanks