how to remove dashes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chiuinggum@hotmail.com - 28 Feb 2007 05:28 GMT

I have a list of 500 part number with dashes in between. Example 1234-56-789.
How do able to remove the dashes to make it 123456789?

Reply to this Message

JE McGimpsey - 28 Feb 2007 05:41 GMT

One way:

=--SUBSTITUTE(A1,"-","")

the -- will convert the text string into ann actual number. If you want
to leave your "number" as text, omit them.

In article <C4B54A4C-0E8D-40E5-B351-8EA0EBA3CD83@microsoft.com>,
chiuinggum@hotmail.com
<chiuinggumhotmailcom@discussions.microsoft.com> wrote:

> I have a list of 500 part number with dashes in between. Example 1234-56-789.
> How do able to remove the dashes to make it 123456789?

Reply to this Message

RichardSchollar - 28 Feb 2007 09:55 GMT

On 28 Feb, 05:28, chiuing...@hotmail.com
<chiuinggumhotmail...@discussions.microsoft.com> wrote:

> I have a list of 500 part number with dashes in between. Example 1234-56-789.
> How do able to remove the dashes to make it 123456789?

You could do them en masse by using Find/Replace ie select the entire
column and press Ctrl+H and in Find What: - and in Replce With:
(leave this blank).

Hope this helps!

Richard

Reply to this Message