SOLVED

Finding and deleting specific text pattern in Excel Workbook

Iron Contributor

We have a CSV export that contains a specific recurring pattern of data that has been placed within brackets (e.g. <varioustexthere>) in a number of cells. 

Is there a way to have Excel identify all the instances of that particular text pattern (finding all instances of "bracketed" data), so that they can be mass deleted without impacting anything else in the workbook?

2 Replies
best response confirmed by OneTechBeyond (Iron Contributor)
Solution

@OneTechBeyond 

Select a single cell (any cell).

Press Ctrl+H to activate the Replace dialog.

Enter  <*>  in the 'Find what' box.

Leave the 'Replace with' box.

Click 'Replace All'.

@Hans Vogelaar this was exactly what I was looking for.  Thank you!

1 best response

Accepted Solutions
best response confirmed by OneTechBeyond (Iron Contributor)
Solution

@OneTechBeyond 

Select a single cell (any cell).

Press Ctrl+H to activate the Replace dialog.

Enter  <*>  in the 'Find what' box.

Leave the 'Replace with' box.

Click 'Replace All'.

View solution in original post