![How Do I Find Multiple Text Matches In Excel For Mac And Delete Them How Do I Find Multiple Text Matches In Excel For Mac And Delete Them](/uploads/1/2/5/4/125499222/251449862.png)
How do I run a multiple find and replace in Excel? Greetings, I have a large dataset where I need to do a multiple find/replace to swap USPS state abbreviations with the full names of the state.
![Mac Mac](/uploads/1/2/5/4/125499222/726873468.jpg)
OK- This may be overly circuitous, but I found a way to do this: 1. Create a new column in the document, put a filler character in the top cell. Run this macro on that column: Sub FillColBlanksOffset 'by Rick Rothstein 2009-10-24 'fill blank cells in column with value above 'Dim Area As Range, LastRow As Long On Error Resume Next LastRow = Cells.Find(What:='.' , SearchOrder:=xlRowsSearchDirection:=xlPreviousLookIn:=xlFormulas).Row For Each Area In ActiveCell.EntireColumn(1).Resize(LastRow). SpecialCells(xlCellTypeBlanks).Areas Area.Value = Area(1).Offset(-1).Value Next End Sub 3.