=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 Number into multiple cell
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 multiple cell
H
