format the data fields in address box

[jankappes]

I cannot click into the data fields to insert spaces or line breaks or
punctuation. Fileds appear in one long string separated by commas.

 

[Rob Giordano [MS MVP]]

stay in one thread please.

Where are you seeing the field as one long string? Sounds like you're
talking about a csv file not xls.

 

[Ed Bennett]

I cannot click into the data fields to insert spaces or line breaks or
punctuation. Fileds appear in one long string separated by commas.

Sounds like you have the address as a single multiline field. AFAIK,
Publisher cannot merge this the way you want. You need to split the
field into multiple fields.