Select the data, then :
<Edit <Replace
In the "Find What" box enter " - " (no quotes),
Leave the "Replace With" box empty,
Then click <Replace All.
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"digital21st"
wrote in message
...
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