Excel2000

wilm106 · 06-04-2005, 03:01 PM

I have a column of numbers 12 16 20
50 33 80

I want to spred the numbers to 3 separate column
12 16 20
50 33 80
How do I do that
Tanks
wilm106

**ReeKorl** · 06-06-2005, 04:21 AM

Just so happens I have a little code lying around here which does exactly that.

What you'll need to do is go into Excel, open your workbook, and click Tools->Macro->Visual Basic Editor. When this opens, right click on your project in the upper left pane (it will probably be called VBAProject (book1) or whatever your workbook is called instead of book 1) and select Insert->Module.

When you have done this, copy the text in the attached file and paste it into the new module (it should be called Module1 - double click on this and a pane will open on the right, this is where you paste the text) then close the VBA editor.

Back in excel, use the following formula:

Code:

In cell B1:
=splitfn(A1," ",1)

In cell C1:
=splitfn(A1," ",2)

In cell D1:
=splitfn(A1," ",3)

This is assuming the combined text is in cell A1 and you want it split out into B1, C1 and D1.

Hope this makes sense! If not, post back and I'll try to explain it a little better.

06-04-2005, 03:01 PM	#1 (permalink)
wilm106 Registered User Join Date: Jun 2005 Posts: 1 OS: window xp	Excel2000 I have a column of numbers 12 16 20 50 33 80 I want to spred the numbers to 3 separate column 12 16 20 50 33 80 How do I do that Tanks wilm106