I only have one thing to say and that is THANK YOU VERY MUCH

"tjtjjtjt" wrote:

If you want FirstName LastName and the first names are in Column A and the
Last Names are in Column B...
Insert a new column to the right of Column B and put this formula in the
first cell:
=A1&" "&B1
Copy it down for all the names.
Then, copy the new list and Edit | Paste Special | Values.
If you want LastName, FirstName, the formula would be:
=B1&", "&A1

tj


"Hombreck" wrote:

I have a file with more the 1000 names and addresses. My proble is that the
firat and last names are in 2 differents cells. I i would like to put it in
teh same cell. Is there anyway I csn do that?
Please help too many names to re-type
Carlos