Formula Help

B

Brittany

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?
 
B

Brittany

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Nameing a function 1
Merging from an Excel file with graphics 1
Report Group Footer DLookUp 0
Index / Match Formula Problem 4
SUMIF with criteria "<>" & "=" 4
Grouping Names in Mail Merge 0
Function to Combine Names and Middle Initital In Various Formats 3

Top