If the data is as you have written it there is a space at the begining
of the text. You could:

1) Create a seperate column and use the trim function eg trim(a2) and
copy it down. Select all and then paste values

or

2) Select all the data edit, replace space (pressing space once in the
find box) with nothing. If Their are multiple spaces this can be
repeated a few times till they disappear, but if genuine spaces appear
in the middle of a text string you could loose them eg firstname
secondname

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=513733