Transposing contents of a cell
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
|