If you have a number like 1-123-456-7890 and you want it to be

1 in a column
123 in another
456 in another
7890 in another

You can use Data-Text to columns selected delimited and for
delimiters
select other and enter "-"


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=513237