First Name Cell Last Name Merge

  • Thread starter Thread starter prmrins
  • Start date Start date
P

prmrins

I have an Excel doc with first name in one cell & last in another. In order
to import to Business Contact Manager I need to have one cell with Last Name,
First (If I'm wrong about this please let me know).

How can I combine these fields into one? There are hundreds on names so I'd
like to merge all at once.

Thank you very much for your help!!!
 
This newsgroup supports Microsoft Access, the relational database.

You'll get more specific suggestions if you (re-)post to a newsgroup
supporting Excel.

However, you could use a formula in an empty column/cell that concatenates
the contents of the two cells with a space between.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
prmrins said:
I have an Excel doc with first name in one cell & last in another. In order
to import to Business Contact Manager I need to have one cell with Last
Name,
First (If I'm wrong about this please let me know).

How can I combine these fields into one? There are hundreds on names so
I'd
like to merge all at once.

Thank you very much for your help!!!
Click to expand...


Is your question about Excel or about Access (the subject of this
newsgroup)? If it's about Excel. while this is not really the correct
forum, you could create a column in your spreadsheet using the formula

=A1 & ", " & B1

or something like that, where [A1] is the last-name cell and [B1] is the
first-name cell.

If your question is about Access, you could write a query that has a
calculated field defining the full name, like this:

SELECT
LastName,
FirstName,
LastName & ", " & FirstName As FullName
FROM YourTable;

Then you would import the query instead of the table directly.
 
Sorry wrong forum but thank you very much for the help!!!

Dirk Goldgar said:
prmrins said:
I have an Excel doc with first name in one cell & last in another. In order
to import to Business Contact Manager I need to have one cell with Last
Name,
First (If I'm wrong about this please let me know).

How can I combine these fields into one? There are hundreds on names so
I'd
like to merge all at once.

Thank you very much for your help!!!
Click to expand...


Is your question about Excel or about Access (the subject of this
newsgroup)? If it's about Excel. while this is not really the correct
forum, you could create a column in your spreadsheet using the formula

=A1 & ", " & B1

or something like that, where [A1] is the last-name cell and [B1] is the
first-name cell.

If your question is about Access, you could write a query that has a
calculated field defining the full name, like this:

SELECT
LastName,
FirstName,
LastName & ", " & FirstName As FullName
FROM YourTable;

Then you would import the query instead of the table directly.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)
Click to expand...
 
Back
Top