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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
