Delete part of number

's Computer Specifications

Hi!

I hope somebody can help me in this matter. I have this number
49-02505-28162-4 in about 1000 cells in Excel and would like to change all to
4902505281624. Does anyone know a simple way to do this to thousands?

's Computer Specifications

I would to add that the numbers are NOT identical, they are all different.

"Stefan" wrote:

> Hi!
>
> I hope somebody can help me in this matter. I have this number
> 49-02505-28162-4 in about 1000 cells in Excel and would like to change all to
> 4902505281624. Does anyone know a simple way to do this to thousands?
>

's Computer Specifications

Hi

Select the range with numbers. Replace All "-" with ""

--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

"Stefan" <(E-Mail Removed)> wrote in message
news:ABF46665-64EB-405F-96B4-(E-Mail Removed)...
> Hi!
>
> I hope somebody can help me in this matter. I have this number
> 49-02505-28162-4 in about 1000 cells in Excel and would like to change all
to
> 4902505281624. Does anyone know a simple way to do this to thousands?
>

's Computer Specifications

Thank you very much, but how do I do this exactly. See, I'm quite new to this.
Thakns in advance.

"Arvi Laanemets" wrote:

> Hi
>
> Select the range with numbers. Replace All "-" with ""
>
>
> --
> Arvi Laanemets
> (When sending e-mail, use address arvil<At>tarkon.ee)
>
>
>
> "Stefan" <(E-Mail Removed)> wrote in message
> news:ABF46665-64EB-405F-96B4-(E-Mail Removed)...
> > Hi!
> >
> > I hope somebody can help me in this matter. I have this number
> > 49-02505-28162-4 in about 1000 cells in Excel and would like to change all
> to
> > 4902505281624. Does anyone know a simple way to do this to thousands?
> >
>
>
>

's Computer Specifications

WOW! I Figured it out all by myself! ;-)
I simply used the replace-function i the Edit-menu. Couldn't be easier.

"Arvi Laanemets" wrote:

> Hi
>
> Select the range with numbers. Replace All "-" with ""
>
>
> --
> Arvi Laanemets
> (When sending e-mail, use address arvil<At>tarkon.ee)
>
>
>
> "Stefan" <(E-Mail Removed)> wrote in message
> news:ABF46665-64EB-405F-96B4-(E-Mail Removed)...
> > Hi!
> >
> > I hope somebody can help me in this matter. I have this number
> > 49-02505-28162-4 in about 1000 cells in Excel and would like to change all
> to
> > 4902505281624. Does anyone know a simple way to do this to thousands?
> >
>
>
>

's Computer Specifications

Great! As an alternate approach, see Help for the SUBSTITUTE worksheet
function.

Jerry

Stefan wrote:

> WOW! I Figured it out all by myself! ;-)
> I simply used the replace-function i the Edit-menu. Couldn't be easier.
>
> "Arvi Laanemets" wrote:
>
>
>>Hi
>>
>>Select the range with numbers. Replace All "-" with ""
>>
>>
>>--
>>Arvi Laanemets
>>(When sending e-mail, use address arvil<At>tarkon.ee)
>>
>>
>>
>>"Stefan" <(E-Mail Removed)> wrote in message
>>news:ABF46665-64EB-405F-96B4-(E-Mail Removed)...
>>
>>>Hi!
>>>
>>>I hope somebody can help me in this matter. I have this number
>>>49-02505-28162-4 in about 1000 cells in Excel and would like to change all
>>>
>>to
>>
>>>4902505281624. Does anyone know a simple way to do this to thousands?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Look up part of a number within a serial number and cpy back assoc	Seantastic	Microsoft Excel Worksheet Functions	9	3rd Nov 2008 04:10 PM
Use the number part	Rudy	Microsoft Excel Discussion	4	21st Dec 2007 02:33 PM
Split or delete part of a number	=?Utf-8?B?T3lzdGVpbg==?=	Microsoft Excel Misc	4	6th Mar 2006 06:37 PM
Part Number/Part Rev db design	AWM	Microsoft Access	0	13th Dec 2004 03:17 AM
Part number surrounded by quotation text qualifier imports as a number not text	John	Microsoft Excel Misc	1	12th Oct 2004 09:51 PM