How to embed a non-breaking space in Excel data being used for a mail merge in Word.

[dragonfly100]

I am trying to keep two merge fields together in a Word mail merge--I would like Address3 which is city, state, to stay on the same line as Postal. In the Word document, non-breaking spaces accomplish this, but I am unable to code the non-breaking spaces into Excel in such a way that they don't get converted to regular spaces upon import. This is a merge of 800+ records.

Any suggestions?

 

[HighAndWilder]

I am trying to keep two merge fields together in a Word mail merge--I would like Address3 which is city, state, to stay on the same line as Postal. In the Word document, non-breaking spaces accomplish this, but I am unable to code the non-breaking spaces into Excel in such a way that they don't get converted to regular spaces upon import. This is a merge of 800+ records.

Any suggestions?

Welcome to Mr Excel.

I would set the worksheet up exactly as you would like to see the data in the Word document.

This would involve setting up another column which concatenates the data from the Address and Postal columns.

Does this help?

 

[dragonfly100]

That seemed like a great solution so i did that, creating a column for "city_state_zip" and changed all the fields in the mail merge. Unfortunately, after all that, when I import the data, it STILL breaks at the spaces between the cities, states and zip codes.

 

[HighAndWilder]

That seemed like a great solution so i did that, creating a column for "city_state_zip" and changed all the fields in the mail merge. Unfortunately, after all that, when I import the data, it STILL breaks at the spaces between the cities, states and zip codes.

When you say 'import the data' do you mean take the Finish and Merge option on the Mailings ribbon in Word?

Do you mean that it forces a line break when it finds a space in a cell value?

 

[dragonfly100]

When you say 'import the data' do you mean take the Finish and Merge option on the Mailings ribbon in Word?

Do you mean that it forces a line break when it finds a space in a cell value?

Yes and yes

 

[HighAndWilder]

Yes and yes

That is weird.

Are you able to use XL2BB to submit 10 or more rogue rows of data and an image of the section of the word document containing the merge variables?

 

[dragonfly100]

That is weird.

Are you able to use XL2BB to submit 10 or more rogue rows of data and an image of the section of the word document containing the merge variables?

I may have misspoke. it does not FORCE a line break, but the line will break at a space. I am trying to keep city, state and zip together.

 

[HighAndWilder]

I may have misspoke. it does not FORCE a line break, but the line will break at a space. I am trying to keep city, state and zip together.

I'm not sure that I understand what the difference is.

Are the values city, state and zip in the same column?

 

[dragonfly100]

I'm not sure that I understand what the difference is.

Are the values city, state and zip in the same column?

This is a directory mail merge.

 

[HighAndWilder]

This is a directory mail merge.

Is it not just wrapping the text because there is not enough space to insert all of the data?