Use Data/ Text to Column a second time on your second column, and this time
use space as the delimiter, and get it to skip the first of those two
columns.

You could have done both operations together, using comma and space as
separators, and skipping the middle column.
--
David Biddulph


"Fran" <Fran @discussions.microsoft.com wrote in message
...
I have an Excel spreadsheet with a column containing general text data in
the format e.g:-

Roberts, M. Tracey

which I want in the format:-

Tracey Roberts

I've managed to separate into 2 cells using the comma as a delimiter but
now
want to get rid of the middle inital and fullstop. Any ideas gratefully
received