Prev: Replace manual line breaks (Alt+Enter) with two spaces for selectedcells
Next: Pick numbers
From: Mia on 21 Mar 2010 08:43
Hi,

I have a problem to make a string of numbers. What I'm trying to do is
following.

Ex. 1
Cell A1
45-0001
Cell B1
5975

The result I want in Cell C1: 450001005975

I'l be wery grateful for some help!

--
Best regards
Mia
From: Barb Reinhardt on 21 Mar 2010 09:21
You can start with this

=replace(A1,"-","") & text(B1,"000000")
--
HTH,

Barb Reinhardt



"Mia" wrote:

> Hi,
>
> I have a problem to make a string of numbers. What I'm trying to do is
> following.
>
> Ex. 1
> Cell A1
> 45-0001
> Cell B1
> 5975
>
> The result I want in Cell C1: 450001005975
>
> I'l be wery grateful for some help!
>
> --
> Best regards
> Mia
From: helene and gabor on 21 Mar 2010 09:22
Hello Mia,

=LEFT(A1,SEARCH("-",A1,1)-1)&RIGHT(A1,SEARCH("-",A1,1)+1)&"00"&B1

Jó szerencsét

Sebő Gábor

"Mia" <Mia(a)discussions.microsoft.com> wrote in message
news:C748F214-5A60-4A61-B504-ED1664F704E9(a)microsoft.com...
> Hi,
>
> I have a problem to make a string of numbers. What I'm trying to do is
> following.
>
> Ex. 1
> Cell A1
> 45-0001
> Cell B1
> 5975
>
> The result I want in Cell C1: 450001005975
>
> I'l be wery grateful for some help!
>
> --
> Best regards
> Mia
>

From: Mia on 21 Mar 2010 10:43
Thank you,

I had god help from your suggestion but I solved it like this.

=Left(B8;2)&Right(B8;4)&TEXT(P29;"000000")

Tahnk yo agian!


--
Best regards
Mia


"Barb Reinhardt" skrev:

> You can start with this
>
> =replace(A1,"-","") & text(B1,"000000")
> --
> HTH,
>
> Barb Reinhardt
>
>
>
> "Mia" wrote:
>
> > Hi,
> >
> > I have a problem to make a string of numbers. What I'm trying to do is
> > following.
> >
> > Ex. 1
> > Cell A1
> > 45-0001
> > Cell B1
> > 5975
> >
> > The result I want in Cell C1: 450001005975
> >
> > I'l be wery grateful for some help!
> >
> > --
> > Best regards
> > Mia
From: Mia on 21 Mar 2010 10:48
Thank you!


--
Best regards
Mia


"helene and gabor" skrev:

> Hello Mia,
>
> =LEFT(A1,SEARCH("-",A1,1)-1)&RIGHT(A1,SEARCH("-",A1,1)+1)&"00"&B1
>
> Jó szerencsét
>
> Sebő Gábor
>
> "Mia" <Mia(a)discussions.microsoft.com> wrote in message
> news:C748F214-5A60-4A61-B504-ED1664F704E9(a)microsoft.com...
> > Hi,
> >
> > I have a problem to make a string of numbers. What I'm trying to do is
> > following.
> >
> > Ex. 1
> > Cell A1
> > 45-0001
> > Cell B1
> > 5975
> >
> > The result I want in Cell C1: 450001005975
> >
> > I'l be wery grateful for some help!
> >
> > --
> > Best regards
> > Mia
> >
>
 |  Next  |  Last
Pages: 1 2
Prev: Replace manual line breaks (Alt+Enter) with two spaces for selectedcells
Next: Pick numbers