If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change entries from last name, first name
I have to combine my list of almost 800 names listed as last name, first
name, with another list which has them as first, then last. Can I somehow correct my entries to read as first then last? Thanks much, djlny |
#2
|
|||
|
|||
Change entries from last name, first name
djlny wrote:
I have to combine my list of almost 800 names listed as last name, first name, with another list which has them as first, then last. Can I somehow correct my entries to read as first then last? Thanks much, djlny If you have the last name, first name in one cell I would use data text to columns to separate them into two columns. FirstName and LastName. Then it's just a matter of cut and paste. gls858 |
#3
|
|||
|
|||
Change entries from last name, first name
Check out this google search result.
http://snipurl.com/kcc9 Gord Dibben Excel MVP On Tue, 29 Nov 2005 14:18:12 -0800, "djlny" wrote: I have to combine my list of almost 800 names listed as last name, first name, with another list which has them as first, then last. Can I somehow correct my entries to read as first then last? Thanks much, djlny |
#4
|
|||
|
|||
Change entries from last name, first name
It is much easier (and better spreadsheet / database construction practice)
to have information like this in different fields. The same goes for addresses where house number, street, locality, town, post or zip code and country should all be in different fields. One reason for this is that it makes it easier to sort and search for data - especially when doing a data cleaning exercise It is very easy to concatenate (join) information for outputting to forms, letters etc. but more difficult to separate it out. Perhaps you would consider breaking the data down into its component parts rather than perpetuating this problem. If you would let us know how you would like to proceed I'm sure someone will help. Regards. Bill Ridgeway Computer Solutions "djlny" wrote in message ... I have to combine my list of almost 800 names listed as last name, first name, with another list which has them as first, then last. Can I somehow correct my entries to read as first then last? Thanks much, djlny |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Loosing some saved journal entries | Skidown92 | General Discussion | 2 | April 26th, 2005 05:07 AM |
auto change number entries | ToddG | Worksheet Functions | 2 | April 25th, 2005 01:46 PM |
copied journal entries not linking to contacts | juanjuan | General Discussion | 0 | April 20th, 2005 01:01 AM |
How do I change multi-line entries to single line entries in Exce. | CPOWEREQUIP | Worksheet Functions | 3 | April 14th, 2005 12:38 AM |
how do I change button color | Vivacious-Lady | Database Design | 1 | October 18th, 2004 05:21 PM |