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.