How to Write an Excel VBA Function. VBA functions are used directly in spreadsheets as formulas, and they help perform repetitive tasks. You can create a custom function—as shown below—and then access it from a cell or a direct reference from a cell. | Data Driven Insights

Remove Text Pattern Using Find and Replace (.*) Did you know you can remove specific text patterns in Excel or any text editor using Find and Replace with Regular Expressions (RegEx)? Here’s how it works: Open Find and Replace. In the Find box, type: .* Leave the Replace box empty. Click Replace All. This removes everything that matches the pattern — effectively clearing the text. It’s a powerful trick when you want to quickly clean data or remove all content following a certain pattern. #Excel