If you're using xl2003 and below, you can select your single column Range and
click on Data on the menu bar.

Then click Text to columns.

You'll be prompted to find out how you want to split the data--either by a
delimiter or by fixed column widths.

Hezzy wrote:

I have no idea what text to column is, what is it?

"Gary''s Student" wrote:

Use Text to Columns
--
Gary''s Student - gsnu200782

--

Dave Peterson