Split and Arrange in Order

Ashu K

unread,

Nov 15, 2015, 2:12:52 AM11/15/15

to Excel VBA Lab

Dear Seniors,

I have data in String like below

Cell A1 : 5954027330207744, 5428168647245824

Cell A2 : 4975726323302400, 5319432557559808, 6694363526594560, 4663845259837440

I want to split and arrange all Numbers below one by one. Output like below :

5954027330207744
5428168647245824
4975726323302400
5319432557559808
6694363526594560
4663845259837440

Kindly help.

Regards

Ashu Kenith

Ashu K

unread,

Nov 17, 2015, 10:31:23 AM11/17/15

to Excel VBA Lab

Dear Seniors,

Please help.

Regards

Ashu Kenith

Ashish Bhalara

unread,

Nov 18, 2015, 12:25:53 AM11/18/15

to Excel VBA Lab

Hi,

See the attached file for required output.

Regards

Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/ce23dd14-fe77-40af-8802-57385c376927%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Split data query.xlsm

Reply all

Reply to author

Forward