Re: Formatting data in word label merging, commas into line breaks

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


"funky Hamsta" <funky Hamsta@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A4CEBD10-DD1A-4531-8992-86012D1AA9C4@xxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • Re: Split
    ... "shapper" wrote in message ... I have a string as follows: ... I need to get all words with no commas or spaces: ... text.Split to get the words then text.Trimto remove the trailing and leading spaces? ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Help with replacement pattern
    ... replace the commas which are not contained within a pair of quotes. ... After all the "" pairs are matched, any commas in the remaining string ... bool isInQuotes = false; ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Text file I/O in VBA
    ... the commas are also handled well into your cleaned ... Dim f1 As Integer ... Dim fInput As String ... Input #1, strLIne ...
    (microsoft.public.access.modulesdaovba)
  • Re: Format a sorted character string
    ... What string did you start with when you got a blank string returned? ... And if you look at the code, it changes commas to spaces, then fixes the spaces, ... Sub testme() ... Dim myStr As String ...
    (microsoft.public.excel.programming)
  • Re: split parameter line with quotes
    ... i'm looking for some way to split up a string into a list of pairs ... The problem is that you are using commas for delimiters at two ... some other delimiter, ... through each character and keep a count of quotation marks. ...
    (comp.lang.python)