Splitting text from cells into table in new worksheet

[Soul_Revolution]

Hi,

I am importing some football game data from a website as in the attached WorkSheet "ImportData" with the aim to analyse information of the goalscorers.

From the imported data I need to be able to spilt different text elements from cells in columns C and F into a different worksheet together with the related MatchID. Each goal being a separate row of data, as shown in the attached worksheet "Goalscorer". I now have a further 300 matches worth of data which needs to be split in the same way.

Although the "Text-to-Columns" feature in Excel will split the data, I don't believe it does so into the format I require.

With my realtivley poor VBA skills I am guessing the Right, Left, Mid and Len functions would be utilised, but I'm not really sure where to make a start.

Any help would be greatly appreciated.

[Special-K]

Use ; as delimiter

[Soul_Revolution]

Hi Special-K,

Thanks for the reply.

In what context do you mean? The Text-to-Columns function?

If so, although this splits the cell, it won't do so in the final format I need, so I was querying whether it is possible to use VBA code to match the format in the 'Goalscorer' worksheet.

[DonkeyOte]

Perhaps a sub routine along the lines of:

Please Login or Register  to view this content.

I have no doubt this could be streamlined but should be a start.

[Soul_Revolution]

DonkeyOte,

Many thanks, this works great. More than just a start!