Remove rows in a single cell when matching text found in the row

Hi

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

Apologies I have pasted the link on other forum but didnot added the link here:

here you go:

https://www.mrexcel.com/forum/excel-...found-row.html

Hi Alan

Any guidance on this issue will be of great help.

Please Login or Register  to view this content.

Thanks Jindon

I have tried your code but I’m getting type mismatch error on below.

For i = 1 to ubound (a,1)

Note: I know it needs to be inserted as code but I’m logged in mobile no options for me

You might have value only in A1...
Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Works perfectly with minor change
Change to

Please Login or Register  to view this content.

Great it works for one cell

Need this to loop through all valid cells in a column

Then obviously your range has blanks...
change to

Please Login or Register  to view this content.

Thanks it’s working great

But noticed one discrepancy where texts like “\SharePoint” are not removed from the cell

apologies repost

Originally Posted by Rem0ram

Thanks it’s working great

But noticed one discrepancy where texts like “\SharePoint” are not removed from the cell

Should remove,

Post your workbook.

Did not get you what is oist your workbook

Can’t share wbook from office

Line looks like below

C:\users\xxxxxx\appdata\local\microsoft\outlook\SharePoint Lists.pst, 271360, (thu, 05 oct 2017 13:23:33 -0600)

Thanks jindon

It only works for internet calendar but not SharePoint

Not sure what’s the issue could nt do much either as I can’t share workbook

Workbook attached works for both with Jindon's original code. Data in column A of Sheet1.
Macro in Module1

Originally Posted by Rem0ram

It only works for internet calendar but not SharePoint

Not sure what’s the issue could nt do much either as I can’t share workbook

No idea why you can not upload a workbook, only just a data that is not working as I don't want to see your actual workbook.
Possibilities;
- Spelled wrong in pattern.
- Case sensitive compare.

If the latter, insert one line

Please Login or Register  to view this content.