I have a column with thousands of rows that has in every cell a cost center
number and the name of the cost center. I need to break the cost center
number and the name of the cost center into two different cells because I
need to run a vlookup for just the cost center number.

Thanks very much for any help.

Make sure the column to the right is empty and do datatext to columns and
select whatever delimiter that's in the cell, maybe a space or a comma and
click finish

Regards,

Peo Sjoblom

"Polina" wrote:

I have a column with thousands of rows that has in every cell a cost center
number and the name of the cost center. I need to break the cost center
number and the name of the cost center into two different cells because I
need to run a vlookup for just the cost center number.

Thanks very much for any help.

Thanks very much for the quick response but I am still a little confused.
If each cell is like this : 00000 - name of cost center, I go to the column
of cells to the right that are empty and type what?

Thanks

"Peo Sjoblom" wrote:

Make sure the column to the right is empty and do datatext to columns and
select whatever delimiter that's in the cell, maybe a space or a comma and
click finish

Regards,

Peo Sjoblom

"Polina" wrote:

I have a column with thousands of rows that has in every cell a cost center
number and the name of the cost center. I need to break the cost center
number and the name of the cost center into two different cells because I
need to run a vlookup for just the cost center number.

Thanks very much for any help.

No, you select the column you want to parse, then click on datatext to
columns (in the menu), click delimited and click next, if you have a hyphen
then check other and put a hyphen there, then click finish

Regards,

Peo Sjoblom

"Polina" wrote:

Thanks very much for the quick response but I am still a little confused.
If each cell is like this : 00000 - name of cost center, I go to the column
of cells to the right that are empty and type what?

Thanks

"Peo Sjoblom" wrote:

Make sure the column to the right is empty and do datatext to columns and
select whatever delimiter that's in the cell, maybe a space or a comma and
click finish

Regards,

Peo Sjoblom

"Polina" wrote:

I have a column with thousands of rows that has in every cell a cost center
number and the name of the cost center. I need to break the cost center
number and the name of the cost center into two different cells because I
need to run a vlookup for just the cost center number.

Thanks very much for any help.