Forum

Notifications
Clear all

Find and Replace problem

2 Posts
2 Users
0 Reactions
80 Views
(@reyaaz)
Posts: 1
New Member
Topic starter
 

Hello, all.

I am trying to delete some information within a large number of cells.
As shown in the cell image, I’d like to delete all info between <uI style=” and /uI>, at the end of the cell.

excel-help-find-and-replace.PNG

I’ve unsuccessfully tried using a regular expression in Find and Replace:

^<uI style="[a-zA-Z ]+/uI>$

Any suggestions, please?

Thanks

 
Posted : 16/08/2022 11:25 am
(@debaser)
Posts: 836
Member Moderator
 

Use <uI style="*/uI> in the find box and leave the replace box blank.

 
Posted : 17/08/2022 3:22 am
Share: