Macro for Excel – convert Google Keyword Tool data for Excel

Note – I am not responsible for any problems that may arise from using a macro!

Let’s say you want to convert Google Keyword Tool data for Excel. See the macro below.

Angela Sevin – The Borneo office, https://flic.kr/p/62Vu2

If you want to copy & paste this kind of table:

Into this one:

, you can use the macro below.

How to use it?

Select and copy the table #1 on Excel, go to Word, run the macro, go to Excel in a new sheet or another place than the original table, paste.

How to install a Macro for Word? Details #1 ». Details #2.

You can DOWNLOAD THE MACRO HERE ».

This is the macro:

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

 

Share on WhatsAppLinks giving error?

Lasă un comentariu

Rules for commenters »

Puteți folosi Gravatar pentru a adăuga avatar (imagine comentarii).