Need a formulae

[isabelly1122]

In column C I have a list of matches with leagues name and kick off time . I need a formula that copy&paste those league names in column D without kick off times. Only league name

 

[vletm]

isabelly1122
Your sample's Sheet1 C-column is empty.

 

[pecoflyer]

Using Power Query
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"World (FIFA),Fifa Club World Cup", type any}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Value.Is(Value.FromText([#"World (FIFA),Fifa Club World Cup"]), type number)),
#"Filtered Rows" = Table.SelectRows(#"Added Custom", each ([Custom] = false)),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Custom"})
in
#"Removed Columns"


How to paste code with power query

 

[isabelly1122]

isabelly1122
Your sample's Sheet1 C-column is empty.

Column D & E, please check this file

 

[isabelly1122]

Using Power Query
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"World (FIFA),Fifa Club World Cup", type any}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Value.Is(Value.FromText([#"World (FIFA),Fifa Club World Cup"]), type number)),
#"Filtered Rows" = Table.SelectRows(#"Added Custom", each ([Custom] = false)),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Custom"})
in
#"Removed Columns"


How to paste code with power query

Can it be done using a formulae?

 

[vletm]

isabelly1122
About Your need as You written in #4:
I need a formula that copy&paste those league names in column D without kick off times. Only league name
Your column D has texts and times
Your column E has texts.
What really You would need to get? ... and where?

 

[vletm]

isabelly1122
Isn't this same as Your other thread?

Formuale to get only League Names.

Hello , there are 2 columns D &E, i need a formuale to get only league names not the time. For example from column E7 to E11 i want Sapain,laliga2 and similarly from E13 to E16 i want only Sapain,laliga. It can be done via copy paste but there is too much data. Thanks

chandoo.org