User chooses last name from combo box, queries for first name matc
This is going back to what I've asked before. Upon somebody's suggestion, I
searched "cascading combo boxes" or something along those lines. I found a
site with code on how to do what I wanted and entered the code correctly, but
all I get is an error message. Here is the code:
Private Sub Lname_AfterUpdate()
On Error Resume Next
Fname.RowSource = "Select tblRoster.Fname " & _
"FROM tblRoster " & _
"WHERE tblRoster.Lname = '" & Lname.Value & "' " & _
"ORDER BY...Separating First Name(s) and Last Name into Separate Columns
I have a spreadsheet with one column ("name") that contains names in the
following formats occuring randomly down the list:
Firstname & Firstname Lastname
Firstname Lastname & Firstname Lastname
I need to get them all into two new columns "firstname" and "lastname" and
I'm having difficulties writing a formula to account for all 3 scenarios in
one cell. (If I have to do it in multiple steps - so be it!)
For the 1st example, the contents of the new "firstname" column should be
Firstname, while the "lastname"...How do I combine "First Name", "Last Name" Fields into a "Name" Fi
I have two tables one has First Name and Last Name fields. The other has
first and last names combined in a "Name" Field. I would like to combine
tables via a query for sorting and mailing purposes. This problem sounds so
simple, but it is beyond me!!!!!
Create a new query. In design view, add the table that has both, then in a
"field" on the grid, add something like:
FullName: [FirstName] & " " [LastName]
Microsoft Office/Access MVP
"Climberjon" <Climberjon@discussions.microsoft.com> wrote in mes...Can I display the e-mal contact list as last name, first name?
New to Outlook 2003. When I open a contact list to address an e-mail, the
names are displayed firt name, last name. I don't like this. Can I have the
list displayed last name, first name as in the actual contact card? Thanks.
You can change the display format of the Outlook Address Book here: Tools
menu > Email accounts > View/Change existing directories/address books >
Click Next > Highlight Outlook Address Book > Click Change
"Mr. Tutt" <Mr. Tutt@discussions.microsoft.com> wrote in message
&g...convert from last name, first name TO first name, last name
How can I convert my contacts (as a group menaing all of them at once0 from
the last name, first name to first name last name, without having to enter
EACH cotnact and perform it almost 400 times?
Also, in what format would you suggest trying to print my contacts showing
fields name mobile, home, work phone and email address? I assume there is a
way to make used defined fields?
You'll need to create a post with enough information that others could
understand it. How are we to know which field or view you are trying to
"convert?" Be specific.
I would suggest pri...Merge different first name, same last name, same address
I have 3291 names and addresses. In order to avoid creating duplicate
labels, I want to merge rows that have the same last name and street address
but different first names.
Jack Smith 123 Elm Street
Jill Smith 123 Elm Street
Jack Jill Smith 123 Elm Street
If the entire name and address is within one cell, you can use the
Data/Text-to-Columns function, and then sort by the address cell.
LACA's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30381
View this thread: h...How do I convert last name, first name in cells to first name las.
Cells contain names in last name, first name order. I wish to convert to
first name last name (no comma) without retyping. Thanks
Assuming your data is in column A. Select the names in Column A. Make sure
that Columns B and C are blank. In Excel 2003, click on data,
text-to-columns and choose delimited and comma. The last name of the first
entry will be in A2 and the first name will be in B2. In C2 type =B2&" "&A2
to concatenate the name with first name first and then copy down the formula
in C2 as far as necessary. As a last step be sure to copy Column C, go ...Excel Newb: Splitting First name and Last name
I have a long list of names in column A that look like this:
How can I split out the names by first name and last name with first
name going in B and Last name going in C? Thank you very much.
You can use the Text To Columns tool on the Data menu, or you can use
formulas. If the full name is in A1, you can get the first name with
and the last name with
However, you need to decide what to do with names with more than two
components. E.g., "John David Smit...Last name, first name
I have a list with lastname, firstname in a cell. I would
like to change it to firsname lastname. Any clues?
Insert a column after your name column, highlight the name
column, go to Data, Text to Columns, Delimited, select
comma, finish. This will give you two columns, lastname,
firstname. Insert a column before your lastname column.
Move the firstname column to the new column. Your third
column should now be blank. Enter in the formula
=CONCATENATE(,A1," ",B1)in the third column. This will put
your firstname space lastname in the third ...Separate first name, middle name and last name
Hello - My worksheet has a range of names (not similar), where some have
first, mid and last names, some have first and last names, first, last and
suffix etc. I came across a tutorial that helped me separate first, mid and
last name, but the forumula doesn't work if there is no middle name.. I want
to create a macro so I don't have to manually do a text-to-column every time.
Eric M Barnes
Edward L Bassard III
Aurora Sofia Garcia
Angela N Higginbotham
Amanda Marie Roccuzzo
Forumla tried -
Left: =LEFT(A3, SEARCH(" ",A3,1)) ...Extracting First Name from cell with first name and last name
I have searched several posts and am still stumped. I have a first
name and last name in Cell B10 on Sheet1. I want to extract the first
name with no spaces. It is part of a bigger code where I am opening
outlook and making an email. The end result is to use the person's
first name in the saluation. I have all the code to do everything
except that I can't figure out how to grab the first name. Any help
would be greatly appreciated. Thanks in advance.
You probably want this...
=LEFT(A1,FIND(" ",A1&" ")-1)
but be advised that it (and m...how do I reveerse name order last name, first name to first name, last name
I have a long database, 27k with names that I want to mail to. The
list is last name, first name. I want to do a global change to first
name, last name. I also want to add "Mr" to it. For example: the
list now is Smith, John. I want to change it to Mr. John Smith for
the entire list.
Assuming there is only one comma in each:
Note that some of the women might be offended.... 27k names, all male?
Don Smith wrote:
> I hav...First Name Last Name Confusion
In Outlook 2003, if I create a new contact and click the 'Full Name'
button I can enter the details in the 'Check Full Name' form as first
'john' and last 'smith'. But on closing the form the Full Name is shown
incorrectly as Mr. Smith John.
'File As' is shown correctly as Smith, John.
Anyone any idea what is causing this?
<FullName Order> is a separate setting from <FileAs> - go into Contact
Options settings and adjust accordingly (the setting will apply to new
contacts - not pre-existing ones)
___________________________...combining last name first name mid initial
I'm a teacher who is responsible for breaking down a file with 2000
students and 200 teachers in 5+ classes each into individual department
There are three NAME cells - Last name, First name, Middle initial in
Row 1: Cell 1 - Jones; Cell 2 - Mary; Cell 3 - Z.
I need to have those three cells for each student combined into one
cell with a formula so that I can cut and paste a section of students
into another excel file so that textbooks can be scanned.
Row 1: Cell 1 - Jones, Mary Z
We've done it in the past, but we've lost the formula.
Thanks for saving my ...Separating a name into first name and last name columns
I have a series of full names in single cells that are formatted the
<Last Name>,<Space><First Name> - thus it looks like the following:
I would like to separate this into two columns and eliminate the comma. I
appreciate any help. I am working in Microsoft Excel 2000 and need answers
in Excel, not in Visual Basic.
David(s) - thank you for the help. Problem solved.
The Davids stick together!!!!
> I have a series of full names in single cells that are formatted the ...delete spaces between last name and first name
I have a table downloaded from a site with a list of names like that:
Alcantara Plata, Rigoberto
I need to get the names with no spaces in between the last name, and first
name, such as:
Any idea son how I can put a condition in a query or SQL?
Any help would be greatly appreciated.
Use the Replace function:
Replace(FullName, " ", "")
Dave Hargis, Microsoft Access MVP
> I ...Last Name, First Name
In version 1.2 we incorreclty set up the database as Last Name, First Name. I
see in Version 3 going forward we change this for new records. Is there a way
I can go into the database and dorrect this to First Name LAst Name, and then
change the format going forward.
In both versions, there is a setting under the system settings to control
this for ongoing updates. Then, you can issue a direct SQL update on the
underlying ContactBase & LeadBase tables to update the fullname field to be
the correct value. Be carefule updating the tables though. This is not a
supported ...Switch Last Name First Name to First Name Last Name
Access 2003. I have a single field called "Name" in a table called "Members".
There is about 300 records in a Last Name First Name format, example
Johnson Jacob Mario
(Some names have Middle Names or Sir's)
How could I run a query to change the names to First Name Last Name? Or if
you recommend in Excel how would I do this?
Jacob Mario Johnson
On Thu, 3 Jun 2010 16:35:15 -0700, Iram <Iram@discussions.microsoft.com>
>Access 2003. I have a si...First Name Last Name
I have a form to enter a First Name Last Name from a keypad on screen.
It works fine to input both First and last name into one field; however
is there a way that when I save the record I can split the first name
and the last name into seperate fields? I know I can enter them
seperatly but I'm trying to do it in one shot. Is there a function that
finds a space between two words, then perhaps another function to enter
whats left of the space, then another to enter whats on the right?
Any help is appreciated
On Sat, 21 Jul 2007 16:29:52 -0500, DS <email@example.com...last name, first name strings
:confused: Hi there,
I am a newbie and am having some trouble with seperating data in
Here is my issue:
I have a table of employee names are in one column alone, but all in a
first name -space- last name
last name, first name
last name -space- first name
What I am needing to do is get all the names to be in the same order
and seperated into two columns as:
Last Name column
First Name column
How do I take those combined name formats that are in one column and
seperate them into seperate columns in the correct order?
data_div...Last Name, First Name extract
Column A has names in it. The format is Last Name, Space First Name. How do I
extract the names so they appear in the same column or another column in this
First Name space Last Name.
Thank You in advance.
If exactly as described
=MID(A1,FIND(", ",A1)+2,99)&" "&LEFT(A1,FIND(", ",A1)-1)
"Tony" <Tony@discussions.microsoft.com> wrote in message
> Column A has names in it. The format is Last Name, Space First Name. How
> extract the...Is there a way I can split last name first name in one cell
I just got a list of customers we need to write about a new store opening.
However, I noticed that the first cell contained the last name of the
customer, then it has a comma, and then it has the first name. How can I
change that to last name in one cell and first name in another.I would of
course buy the program that will do that if there is no way to change that
w/o a special program. O yes yes, how about stripping the duplicates out of
the list, is there a way to do that as well. I'm an old guy, that used
excel for a while, but I can't remember anything anymore,
honestly......How to get Address cards to be in order of First name and then last name (and not in "file as" order)?
After persistent errors when downloading new emails,
I have just copied my contacts across into a new PST file.
The problem is that now in "Address Card" view some names
are in "Last name, then first name" order, whereas many other
entries are in "First name then last name" order.
Looking more closely, if there is a comma between the names then
it always shows the Lastname first.
How do I stop this?!
If I go to "Tools" > "email accounts" > V"iew or change existing
directories or address book"
there is ...FULL NAME in contacts not populating FIRST NAME and LAST NAME corr
I have Office XP with Outlook 2002 SP3 installed and whenever I type a name
in to the FULL NAME field on the contacts form, the form puts the first name
in the LAST NAME field and the last name in the FIRST NAME field. For
example entering "John Smith" in the FULL NAME field and pressing the FULL
NAME button results in the CHECK NAME FORM displaying Smith as the FIRST NAME
and John as the LAST NAME. This happens no matter what the settings are in
the FILE AS box.
It seems to me that you should be looking at the settings you specified for
the Full Name field, not the File As...Outlook 2000 Contacts Email Address Sorts BY First Name Not Last Name
When I open my Contacts to send an email it sorts by first name not last
How can I change the sort so it displays contacts by last name?