arranging external data delimited by comma

[Cicada]

Hello

I am presently using excel to record data posted from an external source (excuse the lack of vocabulary newbie). To be specific it is a card program. The table that the card values are sent to in excel is very simply constructed and appears like this

Cards
Player 1 1, 23, 14
Player 2 2, 7, 25

Thus all three cards are in the same column and delimited by a comma. Now i am aware normally if i wanted to separate these three values into separate columns I would use the text to column fuction this I have tried with no success. I would like these numbers to have their own columns but the problem is that not all the numbers appear at once only one value every round and at the end of each game it is cleared. Is it possible to separate these numbers? any help will be greatly appreciated.

Regards
Dan

[stanleydgromjr]

Cicada,

See the attached workbook "Arranging external data delimited by comma - SPLIT - Cicada - SDG.xls", with a command button "Split Text".


If this does not work correctly, then post your workbook - scroll down and see "Manage Attachments".

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.