How can we split the numbers in cells

0 views
Skip to first unread message

Ashu K

unread,
Jun 15, 2015, 12:59:24 PM6/15/15
to Excel...@googlegroups.com
Dear Seniors,

I have a number in one Cell. Like - 78541256489

I want to split the number in different Cells. How can I split the numbers.



Thanks & Regards
Ashu Kenith

Ashish Kumar

unread,
Jun 16, 2015, 1:28:26 AM6/16/15
to Excel VBA Lab
Hi Ashu,

PFA, Both Solution : Vertical and Horizontal. 



Regards
Ashish Kumar
Split no. in Cells.xlsx

Ashu K

unread,
Jun 16, 2015, 7:43:23 AM6/16/15
to Excel...@googlegroups.com
Dear Ashish,

Thanks a lot for your help.

Superb.

Ashish Kumar

unread,
Jun 16, 2015, 7:46:54 AM6/16/15
to Excel...@googlegroups.com
Dear Ashu,

Welcome.



Regards
Ashish Kumar
Reply all
Reply to author
Forward
0 new messages