Assuming that you now have:

M. Tracey

in C1, then you could use this in D1 to remove the first 3 characters
if there is a full-stop in the

=IF(ISNUMBER(SEARCH(".",C1)),RIGHT(C1,LEN(C1)-3),C1)

Copy down as required.

Hope this helps.

Pete


On Jan 15, 4:17*pm, Fran <Fran @discussions.microsoft.com wrote:
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