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
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,
If your value is in A1,
=SUBSTITUTE(A1,"-","")
HTH
Steve
FYI - my post keeps the ISBN as text.
Steve
cheers
Worked a treat
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" <[email protected]>
wrote in message
news:[email protected]...
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks