Sub TabsFromEntersForExcel() ' ' TabsFromEntersForExcel Macro ' ' 'FIRST, WE PASTE THE TEXT Selection.PasteSpecial Link:=False, DataType:=wdPasteText, Placement:= _ wdInLine, DisplayAsIcon:=False Selection.Find.ClearFormatting 'THEN WE DO A REPLACE Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "^p" .Replacement.Text = "^t" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll 'THEN WE SELECT ALL TEXT AND CUT Selection.WholeStory Selection.Cut End Sub