PC Review


Reply
Thread Tools Rate Thread

unwanted spaces in mail merge docs

 
 
=?Utf-8?B?a2JsYWtlcg==?=
Guest
Posts: n/a
 
      25th Nov 2003
Hi, how do I eliminate unwanted spaces before and after first and last names in mail merge doc
so that I do not have to scan each address and delete spaces manually?
 
Reply With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      25th Nov 2003
You can run a macro

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--

Regards,

Peo Sjoblom


"kblaker" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
> Hi, how do I eliminate unwanted spaces before and after first and last

names in mail merge docs
> so that I do not have to scan each address and delete spaces manually?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recent docs: opened docs, but not new/downloaded docs slong777@gmail.com Windows XP General 1 30th Nov 2005 03:02 AM
How can I replace single spaces with double spaces in a document . =?Utf-8?B?QW1lcmljbkpld2w=?= Microsoft Word Document Management 5 27th Feb 2005 05:22 AM
I cannot type two sequential letters or spaces or back spaces? =?Utf-8?B?VExUaG9tYXM=?= Microsoft Word Document Management 1 30th Nov 2004 09:02 AM
Spaces not being recognized be excel as spaces!! Help! Kevin Microsoft Excel Worksheet Functions 4 11th May 2004 12:05 AM
Help copying a range with spaces to a range without spaces Andy Microsoft Excel Programming 1 23rd Sep 2003 04:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:44 PM.