Hi all,

I have a cell with a number of comma separated values - i.e

Smith, John, London

I want to create a new column with the data item after the last column, but leave everything else where it is (i.e the Smith, John).

Is this possible and can anyone help ?

Thanks