Never mind, it's just something with this particular spreadsheet. I copied
and pasted the columns into a new one and it worked.

"Brittany" wrote:

I have first names in one column and last names in a second column and I need
to combine them in one column for an import. The formula I usually use is
=A1&" "&B1 but for some reason it doesn't want to work for this spreadsheet.
It's Office 2007 and I've saved the file as a regular worksheet. Any ideas?