Hiya Sweep, thanks for this, but this makes it complicated for when I save this as a .csv for import into our Customer Management software.

Is there anyway I can be left with just the first surname without using a formula? Maybe a Macro for going into each cell individually, to remove the remaining names after the first one in each cell ?

(If this makes sense)