| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is this possible?
The web interfaces aren't really needed.
Bernie - They are if your corporate firewall prohibits the use of newreaders. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
