Seperating data into two columns

[melvin]

Hi,

I have one column (200-300 rows deep) of info which has two pieces of information in each cell; a number code, and the corresponding description. I would like to seperate the code from the description in order to create to columns.

E.g. a typical entry would read "0090 Roller#1" in one cell. I would like the "0090" in one column and the "Roller#1" in another in order to create two columns all the way down.

Does anyone know how this is achieved?

Many, many thanks for any assistance

melvin

[pinmaster]

Hi

Data/Text to columns.....use a space as the delimiter .

Jean-Guy

[KellyMcG03]

Melvin,

If your entries are consistant, there is always 4 numbers you may be able to use the "LEFT" Function.

Put this in a blank cell in the same row as the cell you are wanting to split.
(assuming A2 contains the information)
=LEFT(A2,4)
The 4 stands for the left four (4) characters.

There is also a "RIGHT" function (used the exact same way).

Then just copy the column containing the "LEFT" or "RIGHT" functions and then right click on another column and choose PASTE SPECIAL then choose VALUE. That will give you your info without the formula.

I HOPE THIS HELPS!
~Kel

[swatsp0p]

Another option, depending on the structure of your data, would be the Text To Columns function.

This would be beneficial if the numbers are of varying lengths and there is always a space between the number and the text, using the space as the delimiter.

Good Luck.