Is this possible?
 

Hi there,

I have created a database of names & addresses from a software program
called "CLIP" into excel, which in turn will become a label mail merge
in MS word consisting of 900-1000 customers (for a mass mailing).

The problem is, the names were created last, first and I would like to
change them to first last. Is there a way to do that without manually
typing them all in again?

The names are in one column, so I cannot just switch the columns
around.

Thanks for your help...


--
britgirl
------------------------------------------------------------------------
britgirl's Profile: http://www.excelforum.com/member.php...o&userid=29957
View this thread: http://www.excelforum.com/showthread...hreadid=523529

Is this possible?
 

Hi

Try Data/Text to columns. This should be able to split the names into
separate cells for you.
An alternative is to use something like this:
=MID(A2,FIND(" ",A2)+1,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1)
This will find the first <space in A2 and assume that it is the split
between the names. If you have middle names, or Mr or Mrs, it will be more
difficult than this, though.

Andy.

"britgirl" wrote in
message ...

Hi there,

I have created a database of names & addresses from a software program
called "CLIP" into excel, which in turn will become a label mail merge
in MS word consisting of 900-1000 customers (for a mass mailing).

The problem is, the names were created last, first and I would like to
change them to first last. Is there a way to do that without manually
typing them all in again?

The names are in one column, so I cannot just switch the columns
around.

Thanks for your help...


--
britgirl
------------------------------------------------------------------------
britgirl's Profile:
http://www.excelforum.com/member.php...o&userid=29957
View this thread: http://www.excelforum.com/showthread...hreadid=523529

Is this possible?
 

You can insert a column to the right of the names and then select just the
cells with the names and use Data-Text to Columns and let Excel parse the
names on the comma. You'll end up with the last names in the original column
& the first names in the new column.

BE SURE TO WORK ON A COPY OF YOUR DATA


"britgirl" wrote:


Hi there,

I have created a database of names & addresses from a software program
called "CLIP" into excel, which in turn will become a label mail merge
in MS word consisting of 900-1000 customers (for a mass mailing).

The problem is, the names were created last, first and I would like to
change them to first last. Is there a way to do that without manually
typing them all in again?

The names are in one column, so I cannot just switch the columns
around.

Thanks for your help...


--
britgirl
------------------------------------------------------------------------
britgirl's Profile: http://www.excelforum.com/member.php...o&userid=29957
View this thread: http://www.excelforum.com/showthread...hreadid=523529

Is this possible?
 

Your fomula works like a champ Andy, thanks.

There are a few that were already first last, like a company, but I can
go through an sort those by hand.

Thanks again.


--
britgirl
------------------------------------------------------------------------
britgirl's Profile: http://www.excelforum.com/member.php...o&userid=29957
View this thread: http://www.excelforum.com/showthread...hreadid=523529

Is this possible?
 

This has nothing to do with your post, but I am having some difficulty
here.

When I try to email "contact us" I get an error msg, probably due to my
configuration issues here at my client site, saying that my email client
is not properly installed. I can't do anything about it, so I can't even
ask the forum watchdogs my question.

That brings me to my initial question: How do I post a new thread?!
There is no visible link on the webpage saying "Post New Thread" or
anything like that. When I went to FAQs and asked "Post a new thread",
"Create a new thread", "Post a new msg", etc. (every phrasing I could
think of), I still got no answer.

Thanks,

Bill


--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: http://www.excelforum.com/member.php...o&userid=25838
View this thread: http://www.excelforum.com/showthread...hreadid=523529

Is this possible?
 

Bill,

Use a newsreader program, such as Outlook Express, and connect directly to the groups at

msnews.microsoft.com

The web interfaces aren't really needed.

HTH,
Bernie
MS Excel MVP


"ragtopcaddy" wrote in message
...

This has nothing to do with your post, but I am having some difficulty
here.

When I try to email "contact us" I get an error msg, probably due to my
configuration issues here at my client site, saying that my email client
is not properly installed. I can't do anything about it, so I can't even
ask the forum watchdogs my question.

That brings me to my initial question: How do I post a new thread?!
There is no visible link on the webpage saying "Post New Thread" or
anything like that. When I went to FAQs and asked "Post a new thread",
"Create a new thread", "Post a new msg", etc. (every phrasing I could
think of), I still got no answer.

Thanks,

Bill


--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: http://www.excelforum.com/member.php...o&userid=25838
View this thread: http://www.excelforum.com/showthread...hreadid=523529

Is this possible?
 

The web interfaces aren't really needed.

Bernie -
They are if your corporate firewall prohibits the use of newreaders.

Is this possible?
 

Thanks for the suggestion, but I do not have admin rights to my PC here
at the client site, so I can't install Outlook Express (or anything
else for that matter... I'm really missing Firefox these days!)

I suppose the larger question is why a "Post New Thread" button or link
is apparently ommitted from a website whose sole reason for existence is
to post new threads, and why, judging by the content of the FAQ, I am
the only person ever to have had this difficulty?

Bill


--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: http://www.excelforum.com/member.php...o&userid=25838
View this thread: http://www.excelforum.com/showthread...hreadid=523529

Is this possible?
 

I'm using IE6. In my browser, at the top of the thread list is a small bar
with the Icons/Words

New/Reply/Show

If I click on New I see the option to create a new post


"ragtopcaddy" wrote:


Thanks for the suggestion, but I do not have admin rights to my PC here
at the client site, so I can't install Outlook Express (or anything
else for that matter... I'm really missing Firefox these days!)

I suppose the larger question is why a "Post New Thread" button or link
is apparently ommitted from a website whose sole reason for existence is
to post new threads, and why, judging by the content of the FAQ, I am
the only person ever to have had this difficulty?

Bill


--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: http://www.excelforum.com/member.php...o&userid=25838
View this thread: http://www.excelforum.com/showthread...hreadid=523529

Is this possible?
 

I had a similar problem at work where newsgroups were no allowed through
Outlook or Outlook Express. One of the techs gave me this weblink:

http://www.microsoft.com/communities...e-eeb2783fda08

It looks a little different but all the functionality is still there. To
post, go to New Question. You must be registered and logged in to post.
Works fine.



--
Mike
Jacksonville, Florida


"Duke Carey" wrote:

I'm using IE6. In my browser, at the top of the thread list is a small bar
with the Icons/Words

New/Reply/Show

If I click on New I see the option to create a new post


"ragtopcaddy" wrote:


Thanks for the suggestion, but I do not have admin rights to my PC here
at the client site, so I can't install Outlook Express (or anything
else for that matter... I'm really missing Firefox these days!)

I suppose the larger question is why a "Post New Thread" button or link
is apparently ommitted from a website whose sole reason for existence is
to post new threads, and why, judging by the content of the FAQ, I am
the only person ever to have had this difficulty?

Bill


--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: http://www.excelforum.com/member.php...o&userid=25838
View this thread: http://www.excelforum.com/showthread...hreadid=523529

Is this possible?
 

Forgive my apparent density :) , but I'm an access programmer used to
the AccessMonster site where there is a link always available for
posting new threads.

Am I to understand then, that there is no ability to start a new thread
while looking at an existing post? (I'm trying to reassure myself that
this is a reality of the site design and not a deficiency in my
browser.)

This is mildly inconvenient in that one frequently desires to post a
thread after/while viewing threads returned by a fruitless search. I
suppose we're all getting lazy in this day and age, but not having to
return to the forums page (I haven't checked this out yet) or some
other page would be 1 less operation.

Given that the purpose of the site is to post new threads, it would
seem that a link or button to do so should appear prominently on every
page. I can't imagine what the downside to that would be.

I posted here once or twice in the past and had the same problem. I had
to go hunting for a link to post. I have visited thousands of sites in
the interim and remembering the idiosyncracies of these sites is an
impossible expectation.

It just seems that so fundamental a task should be a lot easier to
execute.

Thanks for your help,

Bill


--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: http://www.excelforum.com/member.php...o&userid=25838
View this thread: http://www.excelforum.com/showthread...hreadid=523529

Is this possible?
 

Go to this site:

http://www.microsoft.com/office/comm...&f ltr=&exp=1

Alternatively, go through Google groups

"ragtopcaddy" wrote:


Forgive my apparent density :) , but I'm an access programmer used to
the AccessMonster site where there is a link always available for
posting new threads.

Am I to understand then, that there is no ability to start a new thread
while looking at an existing post? (I'm trying to reassure myself that
this is a reality of the site design and not a deficiency in my
browser.)

This is mildly inconvenient in that one frequently desires to post a
thread after/while viewing threads returned by a fruitless search. I
suppose we're all getting lazy in this day and age, but not having to
return to the forums page (I haven't checked this out yet) or some
other page would be 1 less operation.

Given that the purpose of the site is to post new threads, it would
seem that a link or button to do so should appear prominently on every
page. I can't imagine what the downside to that would be.

I posted here once or twice in the past and had the same problem. I had
to go hunting for a link to post. I have visited thousands of sites in
the interim and remembering the idiosyncracies of these sites is an
impossible expectation.

It just seems that so fundamental a task should be a lot easier to
execute.

Thanks for your help,

Bill


--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: http://www.excelforum.com/member.php...o&userid=25838
View this thread: http://www.excelforum.com/showthread...hreadid=523529