I need help on removing sections of text out of a huge workbook I'm building. For example, it currently reads this in one of them (they all follow the same pattern):
• Examine: Access control policy; procedures addressing account management; security plan; system design documentation; system configuration settings and associated documentation; list of active system accounts and the name of the individual associated with each account; list of conditions for group and role membership; notifications or records of recently transferred, separated, or terminated employees; list of recently disabled system accounts along with the name of the individual associated with each account; access authorization records; account management compliance reviews; system monitoring records; system audit records; other relevant documents or records; list of devices and other systems authorized to connect to organizational systems.
• Interview: Personnel with account management responsibilities; system or network administrators; personnel with information security responsibilities.
• Test: Organizational processes account management on the system; mechanisms for implementing account management.
I need it to just have the bullet for examine and remove all the text related to the interview and test bullet points. So it would wind up like this-
• Examine: Access control policy; procedures addressing account management; security plan; system design documentation; system configuration settings and associated documentation; list of active system accounts and the name of the individual associated with each account; list of conditions for group and role membership; notifications or records of recently transferred, separated, or terminated employees; list of recently disabled system accounts along with the name of the individual associated with each account; access authorization records; account management compliance reviews; system monitoring records; system audit records; other relevant documents or records; list of devices and other systems authorized to connect to organizational systems.
Is there a way to avoid doing this manually? I've got 600+ rows and they all have varying comments and text lengths.
Thanks!
• Examine: Access control policy; procedures addressing account management; security plan; system design documentation; system configuration settings and associated documentation; list of active system accounts and the name of the individual associated with each account; list of conditions for group and role membership; notifications or records of recently transferred, separated, or terminated employees; list of recently disabled system accounts along with the name of the individual associated with each account; access authorization records; account management compliance reviews; system monitoring records; system audit records; other relevant documents or records; list of devices and other systems authorized to connect to organizational systems.
• Interview: Personnel with account management responsibilities; system or network administrators; personnel with information security responsibilities.
• Test: Organizational processes account management on the system; mechanisms for implementing account management.
I need it to just have the bullet for examine and remove all the text related to the interview and test bullet points. So it would wind up like this-
• Examine: Access control policy; procedures addressing account management; security plan; system design documentation; system configuration settings and associated documentation; list of active system accounts and the name of the individual associated with each account; list of conditions for group and role membership; notifications or records of recently transferred, separated, or terminated employees; list of recently disabled system accounts along with the name of the individual associated with each account; access authorization records; account management compliance reviews; system monitoring records; system audit records; other relevant documents or records; list of devices and other systems authorized to connect to organizational systems.
Is there a way to avoid doing this manually? I've got 600+ rows and they all have varying comments and text lengths.
Thanks!
