cell separation

Hello i have a question.

How can i separate a cell in multiple cells to the right by using as a criteria "," ?

First example goes like this 64585868676, 4859859898569, 58595895

The second criteria is a little bit more complex.

Let's say i have two addresses like:
Garden avenue, Athens, 15562, Skra 55, Holargos, 16785

I would like to separate to the right the addresses like

Column A Column B Column C
Garden avenue Athens 15562

and the second address to be printed in a separate sheet. I don't care to know how to create a separate sheet, but how to take the value and paste it in there.

Could anyone help?

Thanks in advance

Use 'Text to Columns' ~ under Data menu in 2010, in the data tools section. Once you start the wizard there are 3 steps. 1) Choose type (select 'Delimited' NEXT 2) For the delimiter, choose comma (by checking the comma box) NEXT 3) Pick the Column Data type(s) [you may want to select 'Text' for all the fields? Especially if the number field has a Leading 0 in it.
From you example, you will have 6 columns of data...you can then copy the last 3 cells and paste to your other sheet.

Originally Posted by queuesef

Use 'Text to Columns' ~ under Data menu in 2010, in the data tools section. Once you start the wizard there are 3 steps. 1) Choose type (select 'Delimited' NEXT 2) For the delimiter, choose comma (by checking the comma box) NEXT 3) Pick the Column Data type(s) [you may want to select 'Text' for all the fields? Especially if the number field has a Leading 0 in it.
From you example, you will have 6 columns of data...you can then copy the last 3 cells and paste to your other sheet.

The problem is that this must be done in VBA because there's more it and all of these elements will be automatically submitted to a database

It would be much easier if you upload a 'good' example WITH your expected results....without it it's like trying to solve World Peace. Also, better details. What is 'There's more it and all of the elements..." Perhaps if your data was in a CSV file and you brought it into excel, you could specify the COMMA as the separator and bring into DB.

Ok here you go.

I have highlighted the desired outcome with red. I believe now that it's clear what i want. Thank you for your reply

That's exactly it! Thank you so much for your help!