This is *EXACTLY* what I'm looking for! Thank you so much for the time and effort you've spent in answering my email and giving me directions! Thank you again!
On Thu, Nov 19, 2020 at 2:48 PM Brian Barker <b.m.bar...@btinternet.com> wrote: > At 13:50 19/11/2020 -0600, Aloris Te wrote: > >Thank you all so much for the incredibly informative tutorial! When > >I searched help, I was unable to find anything about the "pilcrow" > >or how to get rid of extra paragraph breaks. Thanks again for that! > > No probs! > > >For the record, when I have my info, it shows up as such in Writer: > >Jane Smith <tab> 123 Main Street <tab> City ST 12345<pilcrow> > >John Smith <tab> 234 Main Street <tab> City ST 12345<pilcrow> > >Jane Doe <tab> 345 Main Street <tab> City ST 12345<pilcrow> > >John Doe <tab> 456 Main Street <tab> City ST 12345<pilcrow> > > > >The question now would be how to get it from the above format into > >the below when putting it into the Spreadsheet (with each name & > >address in it's own cell, label ready for USPS): > >Jane Smith > >123 Main Street > >City ST 12345 > >John Smith > >234 Main Street > >City ST 12345 > >Jane Doe > >345 Main Street > >City ST 12345 > >John Doe > >456 Main Street > >City ST 12345 > > > >How would I replace a tab in the Find & Replace menu with a line break? > > Wow! This is more difficult that it looks - or perhaps ought to be. > You cannot, as far as I know, replace anything with a line break. And > if you replace your tabs with paragraph breaks, you would get back to > your original problem: that each line of each address ends up in a > separate spreadsheet cell. > > But it can be done. Here's one way: > o Select all the material in the text document. > o Go to Table | Convert > | Text to Table... . > o Select Paragraph for "Separate text at". > o OK. > o Go to Edit | Find & Replace... . > o Enter "\t" (no quotes) in "Search for" and "\n" (no quotes) in > "Replace with". > o Click More Options and ensure "Regular expressions" is ticked. > o Replace All. > o Select the entire table. > o Copy and paste into your spreadsheet. > > I trust this helps. > > Brian Barker > >
