Edwin,

That worked a lot better but it did not move all the entries and
can't see why it should have left them.

Some of the entries had a comma after the first name, but even whe
this was removed there was still no change.
I should have said that the data was in Column C as even when
highlighted that column it did alter column A data.

Can't see a pattern as to why some entries are left and others moved a
it clearly has moved successfully quite a lot of them and saved me
lot of time.The following is a typical example of what was not move
The first column is a cell number and the second is the publication
the third is the data I am working on.

9415 Medical_0380.tif Daniels Isaac Khan
9416 Medical_0380.tif Loghumael Attiba
9417 Medical_0380.tif Daniels Thomas Francis
9418 Medical_0380.tif Danks Robert Miller

I did discover that a Cot followed by a Charles in the next row clearl
left the Charles as the two started with the same letter C. If I wante
to compare more that one letter say 2 or 3 what would be the easies
way to do this?

Thanks for your help and patience
Joh

--
Message posted from http://www.ExcelForum.com