breaking text in one cell into two cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top