This is a duplicate from ExcelForum as well: appreciate your guidance for this.
https://www.excelforum.com/excel-pr...tching-text-found-in-the-row.html#post5045631
I have scenario like below:
For example a sample cell will be like:
Test Outlook.pst and test path
Temp Internet Calendar and test path
Dummy SharePoint and Test site
Find User.pst and True Site
The above content are in one single cell and each row is separated by a carriage line break (char (10)).
I want to look each cell in a column and remove only the lines in each cell which contains text "Internet Calendar" or "SharePoint" and return the rest of the content in the same single cell.
The Output should look like this:
"Test Outlook.pst and test path
Find User.pst and True Site"
Not sure if this is achievable i have been thinking but could not find a way to solve this.
Best
Rem0
https://www.excelforum.com/excel-pr...tching-text-found-in-the-row.html#post5045631
I have scenario like below:
For example a sample cell will be like:
Test Outlook.pst and test path
Temp Internet Calendar and test path
Dummy SharePoint and Test site
Find User.pst and True Site
The above content are in one single cell and each row is separated by a carriage line break (char (10)).
I want to look each cell in a column and remove only the lines in each cell which contains text "Internet Calendar" or "SharePoint" and return the rest of the content in the same single cell.
The Output should look like this:
"Test Outlook.pst and test path
Find User.pst and True Site"
Not sure if this is achievable i have been thinking but could not find a way to solve this.
Best
Rem0
