From: Brittany on
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?
From: Brittany on
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?