Hello Community!
I come to you again in my hour of need. I have a task to update roughly 30,000 medical consent forms in Excel. I have been putting together scripts to automate the process, but I am stuck. I need a script that I can give it a couple of words to start a search and then a couple to stop and delete any text in the middle. Like the following:
[FONT="]We the People of the United States, in Order to form a more perfect Union, establish Justice, insure [/FONT]domestic Tranquility[FONT="], provide for the common [/FONT]defence[FONT="], promote the general [/FONT]Welfare[FONT="], and secure the Blessings of Liberty to ourselves and our [/FONT]Posterity[FONT="], do [/FONT]ordain[FONT="] and establish this Constitution for the United States of America.
Beginning text: We the People
End text: United States of America
Delete everything... beginning text, middle, and end.
I apologize if this is in another post. I have been searching online for 2 hours now. Thanks![/FONT]
I come to you again in my hour of need. I have a task to update roughly 30,000 medical consent forms in Excel. I have been putting together scripts to automate the process, but I am stuck. I need a script that I can give it a couple of words to start a search and then a couple to stop and delete any text in the middle. Like the following:
[FONT="]We the People of the United States, in Order to form a more perfect Union, establish Justice, insure [/FONT]domestic Tranquility[FONT="], provide for the common [/FONT]defence[FONT="], promote the general [/FONT]Welfare[FONT="], and secure the Blessings of Liberty to ourselves and our [/FONT]Posterity[FONT="], do [/FONT]ordain[FONT="] and establish this Constitution for the United States of America.
Beginning text: We the People
End text: United States of America
Delete everything... beginning text, middle, and end.
I apologize if this is in another post. I have been searching online for 2 hours now. Thanks![/FONT]
