Dum
If numbers are consistent you could use DataText to ColumnsFixed Width to
break into 4 columns.
Gord Dibben Excel MVP
On Mon, 21 Mar 2005 15:53:04 -0800, "Dummy"
wrote:
How do I dissect a large number (one column) into four (columns) keeping
their own identity. I have a software that download (chart of accounts) into
excel but this number is conected with activities during the year, and I like
to break down into the Assets, revenue, inventory, expenses. example
1111400000 (one column) into 1-1114-00-000 (four columns) "Assets".
|