Hi Guys

Is there a formula that can strip the dashes from a number.

for example.

a book isbn 0-914918-21-4

a forumula that would remove the '-' to make it 0914918214

Cheers


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=544688