Re: I want to convert

From: Don Guillett (donaldb_at_281.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 06:56:44 -0500

I meant to say that it CAN replace the original column, if desired. 

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"Rossy77" <rossy77@lycos.it> wrote in message
news:RMWuc.269290$hc5.11646001@news3.tin.it...
> Thanks Arvi!
> Sorry if I've been short but I'm a beginner..you've been very kind!(unlike
> italian users)
> The right formula is
> =SUBSTITUTE(SUBSTITUTE(A2,"Cost: ","")," D","")
> It works!!!
> Thanks for your excel lesson..
> Rossella
>
> "Arvi Laanemets" <garbage@hot.ee> ha scritto nel messaggio
> news:uKZh6HyREHA.3300@TK2MSFTNGP09.phx.gbl...
> > Hi
> >
> > Only this string ?  :-)
> >
> > You didn't give enough info for us to help you effectively!
> >
> > Is "Cost: " always a part of string? When yes, then you can remove it
> using
> > SUBSTITUTE function. P.e. with your strin in A2:
> > =SUBSTITUTE(A2,"Cost: ","")
> > returns 120000 D
> >
> > Now about tail part. When this is too always same, then you can use
> > SUBSTITUTE again, with result of first formula as source:
> > =SUBSTITUTE(SUBSTITUTE(A2,"Cost: ","")," D","")
> >
> > When it is always a single character preceeded with space, then
> > =LEFT(SUBSTITUTE(A2,"Cost: ",""),LEN(SUBSTITUTE(A2,"Cost: ",""))-2)
> >
> > When it can contain any number of characters, then probably you use MID
> > function to retrieve numeric part from result of substitute, determing
the
> > lenght of it using FIND function and searching for space. And maybe you
> need
> > to check for absence of cpace (and characters) in string too.
> >
> >
> > --
> > Arvi Laanemets
> > (Don't use my reply address - it's spam-trap)
> >
> >
> >
> > "Rossy77" <rossy77@lycos.it> wrote in message
> > news:4cGuc.266112$hc5.11485726@news3.tin.it...
> > > I have this string (a result of a web query)
> > >
> > > Cost: 120000 D
> > >
> > > and I want to copy this on another cell but in this way
> > >
> > > 120000
> > >
> > >
> > > what do I have to do?
> > > Thanks
> > > Rossella
> > >
> > >
> >
> >
>
>