RE: $$Excel-Macros$$ Split Number into multiple cell

2012-03-05 Thread Rajan_Verma
=Transpose(Mid(A1,Row(Indirect("1:" & Len(A1"))),1)) with CSE -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ICWAI Help Sent: Mar/Mon/2012 07:28 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Split N

Re: $$Excel-Macros$$ Split Number into multiple cell

2012-03-05 Thread dguillett1
Why not just use data>text to columns>fixed width>> Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: ICWAI Help Sent: Monday, March 05, 2012 7:58 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Split Number into m

$$Excel-Macros$$ Split Number into multiple cell

2012-03-05 Thread ICWAI Help
Hi Ashish, could you plese tell me the formula for Spliting number into multiple cell appriciate fi you have vba code but it shouold be dynamics 12345 like 1 2 3 4 5 in multiple columnsa -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread title