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
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
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
Check out this google search result.
http://snipurl.com/kcc9
Gord Dibben Excel MVP
On Tue, 29 Nov 2005 14:18:12 -0800, "djlny" <[email protected]>
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
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" <[email protected]> wrote in message
news:[email protected]...
>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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks