Data/ Text to columns/ delimited/ use the hyphen as delimiter.
--
David Biddulph

"Isa" wrote in message
...
Hi,

Is there a tool or option in Excel which will allow me to transfer a list
in
a column into column headings?

For example, a list with values 1-2-3-4-5 in each row which would be
transferred into 5 columns with headings 1-2-3-4-5.

Thanks.

Isa.