I have one column of data which has multiple parts of data (surname, first name, number etc.) which I need to split into separate columns. The problem is each part of the data is not the same length in characters (e.g. surname can vary wildly), although all data items are split by a space or comma.
Is there any (easy) way/formula I can split these out?
Thank you
Is there any (easy) way/formula I can split these out?
Thank you