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.