Copy Data from Wordpress Tags Bar to Excel

Sorry, I don't understand. What is the problem?

When I copy the Tags(text) as shown in Image 1 (first from left side) and paste it into excel it get pasted as
Remove term: benefits for riders benefits for ridersRemove term: Bike ride with Bykea Bike ride with BykeaRemove term: bike rider karachi bike rider karachiRemove term: bykea bykeaRemove term: bykea app bykea appRemove term: bykea mobile phone snatching coverage bykea mobile phone snatching coverageRemove term: bykea rider requirements bykea rider requirementsRemove term: bykea riding partners requirements bykea riding partners requirementsRemove term: motorcycle riders motorcycle ridersRemove term: parcel delivery service parcel delivery serviceRemove term: requirements for Bike rider at bykea requirements for Bike rider at bykeaRemove term: riders accidental coverage riders accidental coverageRemove term: riding partners riding partnersRemove term: skills required for bykea rider skills required for bykea rider

While I want the paste output as shown in Image 2

Do you mean it appears all in one cell?

Which version of Excel are you using now?

I am using Office 2016 , if I select Paste Special and Text or unicode it get paste into different cells of a row,
if I select HTML then it get pasted in a single cell

Please update your forum profile and please stop quoting posts - it's not necessary when you are responding to the one before yours.

Please attach a workbook with the data as it appears if you use the Paste Special > Text option.

Just out of interest, is there a reason why you are not using the refreshable web query option? As you have PowerQuery in Excel 2016, you might be able to make this automatic. Do you have a link to the data online?

I didn't understand any of your last post. Could you please answer the questions I asked?

OK - thanks, that clarifies that.

As you have now marked this thread as solved, please share your solution.

OK - I shall remove the SOLVED tag, then. This is a help forum, and others may have ideas to share with you.

This solution uses PowerQuery to process the data from the HTML dump/paste in column A.

M Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Paste AS HTML", type text}}),
    #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Changed Type", {{"Paste AS HTML", Splitter.SplitTextByDelimiter("Remove term:", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Paste AS HTML"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Paste AS HTML", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type1", each ([Paste AS HTML] <> "")),
    #"Added Custom" = Table.AddColumn(#"Filtered Rows", "Custom", each Text.Length([Paste AS HTML])),
    #"Inserted Integer-Division" = Table.AddColumn(#"Added Custom", "Integer-Division", each Number.IntegerDivide([Custom], 2), Int64.Type),
    #"Added Custom1" = Table.AddColumn(#"Inserted Integer-Division", "Custom.1", each Text.Start([Paste AS HTML],[#"Integer-Division"])),
    #"Inserted Trimmed Text" = Table.AddColumn(#"Added Custom1", "Trim", each Text.Trim([Custom.1]), type text),
    #"Removed Columns" = Table.RemoveColumns(#"Inserted Trimmed Text",{"Paste AS HTML", "Custom", "Integer-Division", "Custom.1"})
in
    #"Removed Columns"

No problem.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.