Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Here's the deal, we merge excel columns into address labels. Everything works great. Problem is when we have an address where there's no first or last name, just a company name. WE set up the labels like this: <<First <<Last <<Company <<Address etc When there's no first or last name, the space that we manually insert in word remains there, so that when the company name gets moved up to the top line it ends up looking like this: Company X 123 Main Street Anytown, CA The company name is indented by that one space. Is there any way to get Word (or Excel) to ignore that space if there's no first name and last name? -- caustin ------------------------------------------------------------------------ caustin's Profile: http://www.excelforum.com/member.php...o&userid=35200 View this thread: http://www.excelforum.com/showthread...hreadid=549655 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The solution is in Word, in the mail merge document. Go to Insert Word Field
in the mail merge toolbar. In the dropdown list choose If ... then ... else ..... Choose your first name field under Field Name. Under Comparison, choose "is blank". Then enter nothing and a space in the other two areas. "caustin" wrote: Here's the deal, we merge excel columns into address labels. Everything works great. Problem is when we have an address where there's no first or last name, just a company name. WE set up the labels like this: <<First <<Last <<Company <<Address etc When there's no first or last name, the space that we manually insert in word remains there, so that when the company name gets moved up to the top line it ends up looking like this: Company X 123 Main Street Anytown, CA The company name is indented by that one space. Is there any way to get Word (or Excel) to ignore that space if there's no first name and last name? -- caustin ------------------------------------------------------------------------ caustin's Profile: http://www.excelforum.com/member.php...o&userid=35200 View this thread: http://www.excelforum.com/showthread...hreadid=549655 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() thanks so much, that worked perfectly! -- caustin ------------------------------------------------------------------------ caustin's Profile: http://www.excelforum.com/member.php...o&userid=35200 View this thread: http://www.excelforum.com/showthread...hreadid=549655 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove trailing spaces from multiple columns in Excel | Excel Worksheet Functions | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
User Form to Mail Merge | New Users to Excel | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Mail merge to a chart | Charts and Charting in Excel |