Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-25-2023, 07:53 AM
FMH FMH is offline How to delete 2nd nonsequential occurrence of item to end of document Mac OS X How to delete 2nd nonsequential occurrence of item to end of document Office 2019
Novice
How to delete 2nd nonsequential occurrence of item to end of document
 
Join Date: May 2023
Posts: 2
FMH is on a distinguished road
Default How to delete 2nd nonsequential occurrence of item to end of document

I have a list of Spanish words followed by a paragraph mark, followed by its translation, followed by another Spanish word and another paragraph mark. I want to delete every paragraph mark that follows a Spanish word or phrase and replace it with a tab and then continue that same process to the end of the file. It's a list of a thousand words. Here's an excerpt:

la televisión[prg mark]
television[prg mark]
amar[prg mark]
to love[prg mark]
el/la bebé[prg mark]
baby[prg mark]
regular[prg mark]
regular[prg mark]


describir[prg mark]
to describe[prg mark]
la dieta[prg mark]
diet[prg mark]
la banda[prg mark]
band[prg mark]

I want to repeat that delete-and-replace all the way to the end of the file. Anyone have a clue how I can achieve that? I've searched for macros online and 1) they might as well be written in Greek and 2) they never address this particular thing.
Reply With Quote
 

Tags
delete 2nd occurrence



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete 2nd nonsequential occurrence of item to end of document Searching a Word document with multiple words from a list (over 1,000 terms) and BOLD all occurrence Nicknamednick Word 9 09-28-2022 05:41 PM
How to delete 2nd nonsequential occurrence of item to end of document Highlight every occurrence of ... eduzs Word VBA 7 06-27-2020 12:58 PM
How to delete 2nd nonsequential occurrence of item to end of document Copying data related to one item to worksheet with many instances of the same item nmp13 Excel 3 02-06-2016 02:13 AM
How do I delete an Outlook appointment item with VBA? Joe Patrick Outlook 0 07-14-2011 06:56 AM
How to Delete Outlook Item with VBA Joe Patrick Outlook 0 07-14-2011 06:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft