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.