breaking text in one cell into two cells

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 data>text 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 data>text 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 data>text 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 data>text 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.