Extract 2 different texts from one column to 2 columns

[coolx72]

Hi again,

Once more thank you for all your help and share your expert knowledge.

I have a football league schedule with both teams on de same column.

I have a column with all temas and what I would like to have is each team in 2 different columns.

The only way I found was to insert a comma to separate the teams, delete the space after comma, and then text to columns (please see file attached)

Is there an automatic way to do it faster?

Thank you very much in advance.

[sintek]

Hi coolx72

One way I suppose...

Please Login or Register  to view this content.

[coolx72]

Hello SIntek,
In fact your macro helps but does the easier part, that I can do with "text to columns"

The most important would be based on the 20 teams names pass from Initial table to Intermediate, where each team from the Teams would appeared split by a comma in order to pass from that to Final Result with your ,macro.

Thank you very much

[sintek]

In fact your macro helps but does the easier part, that I can do with "text to columns"

The only way I found was to insert a comma to separate the teams, delete the space after comma, and then text to columns

Perhaps you should upload a before sheet with a after sheet depicting your exact requirement which will allow us to understand your requirement...

[coolx72]

Hello Sintek,
Thank you for your message and effort.

I thought that I have been clear:
"The only way I found was to insert a comma to separate the teams, delete the space after comma, and then text to columns (please see file attached)"

Obviously I was not.

I attached the file what is the goal of this request.

Thank you so much for your time.

BR

[sintek]

I'm sorry coolx72

It might be easier for you to distinguish between the two teams as you know who they are...but how is the code to know if the teams are called 7Up Venta & los Pacos or 7Up & Venta los Pacos or 7Up Venta los & Pacos ...

[jindon]

This doesn't work on Mac, but if you have Windows PC, this would be the one you want.

Please Login or Register  to view this content.

[sintek]

All I can say is WOW...
jindon...you never seize to amaze me...

[coolx72]

Hi Jindon,
Even I'm too short to understand your macro, I just can say that was amazing.

Just tested on Parallels and works GREAT !

Thank youuu so much. Unbelievable !

[jindon]

You are welcome and thank for the rep.

[mohan.r1980]

@Jindon,

Nice solution Jindon Sir