Formuale to get only League Names.

[isabelly1122]

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

 

[mohamed ilyas]

Hi isabelly,

please find the attached.. note this will help if you are using office 365, let me know if you are using different version of excel or if formula not working!

regards
ilyas