I haven't been able to find a tool online via google searches that would allow be to do the following conversion. Take these 3 lines of text: Last Name, First Name Street Address City, State, Zip and allow me to paste them into Excel as Cell A, Cell B and Cell C automatically. I have about 300 names and address on a document used for mailing labels and I would like to import this data into a spreadsheet. Thanks in advance
See http://www.gmayor.com/convert_labels_into_mail_merge.htm and jump in where the process matches your document. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Morgan Montague wrote: > I haven't been able to find a tool online via google searches that > would allow be to do the following conversion. > > Take these 3 lines of text: > > Last Name, First Name > Street Address > City, State, Zip > > and allow me to paste them into Excel as Cell A, Cell B and Cell C > automatically. I have about 300 names and address on a document used > for mailing labels and I would like to import this data into a > spreadsheet. > Thanks in advance
Thank you. This procedure looks like it may do exactly what I am looking for. Thanks again. "Graham Mayor" wrote in message news:u72%23tzTEIHA.4228@TK2MSFTNGP02.phx.gbl... > See http://www.gmayor.com/convert_labels_into_mail_merge.htm and jump in > where the process matches your document. > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > Morgan Montague wrote: >> I haven't been able to find a tool online via google searches that >> would allow be to do the following conversion. >> >> Take these 3 lines of text: >> >> Last Name, First Name >> Street Address >> City, State, Zip >> >> and allow me to paste them into Excel as Cell A, Cell B and Cell C >> automatically. I have about 300 names and address on a document used >> for mailing labels and I would like to import this data into a >> spreadsheet. >> Thanks in advance > >
