So i've just thought of finding all the Mr, Mrs etc and getting rid of
them as a last resort.. (even though i would like to keep them) except
when you do a find and replace, it replaces them with a space... so
when you do the text to colums it puts the space in its own colum.. so
the names are all over the place...


--
blander
------------------------------------------------------------------------
blander's Profile: http://www.excelforum.com/member.php...o&userid=36486
View this thread: http://www.excelforum.com/showthread...hreadid=571327