Formatting data in word label merging, commas into line breaks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

funky Hamsta - 07 Apr 2006 14:57 GMT

When making labels for posting letters, I have a data field in my excel table
which has the address data in the following format:

" Mr A B Bloggs, 12 Nowhere Raod, Somewhere, Shireshire, SN12 4UP. "

How can I point word mail merge at this data field and get it to insert a
line break where it sees a comma? so that there format becomes:

Mr A B Bloggs
12 Nowhere Road
Somewhere
Shireshire
SN12 4UP

Any suggestions/solutions greatly appreciated.

Reply to this Message

Doug Robbins - Word MVP - 07 Apr 2006 19:25 GMT

You cannot do it as part of the mailmerge process.

You should use Edit > Replace on the data source to replace all of the
commas with ^p (paragraph returns)

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When making labels for posting letters, I have a data field in my excel
> table
[quoted text clipped - 12 lines]
>
> Any suggestions/solutions greatly appreciated.

Reply to this Message

macropod - 08 Apr 2006 11:28 GMT

Hi,

Word's fields don't support this kind of data manipulation. Your best option
might be to edit the Excel data, by replacing the commas and their trailing
spaces with line feeds. In excel you'd do this via Find/Replace where the
'find' string is a commas and trailing space, and the 'replace string is
ASCII 10 - which you can enter as Alt-010.

Cheers

> When making labels for posting letters, I have a data field in my excel table
> which has the address data in the following format:
[quoted text clipped - 11 lines]
>
> Any suggestions/solutions greatly appreciated.

Reply to this Message