Prev: Replace manual line breaks (Alt+Enter) with two spaces for selectedcells
Next: Pick numbers
From: Rick Rothstein on 21 Mar 2010 11:30
Just to point out, Barb used the wrong function in her response to you...
she should have used SUBSTITUTE instead of REPLACE. Try her formula this
way...

=SUBSTITUTE(A1,"-","") & TEXT(B1,"000000")

--
Rick (MVP - Excel)



"Mia" <Mia(a)discussions.microsoft.com> wrote in message
news:F19D06C4-8A60-4F9C-946A-06DCE0787143(a)microsoft.com...
> 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: Dana DeLouis on 21 Mar 2010 11:34
> The result I want in Cell C1: 450001005975

Other ways as stated....

=SUBSTITUTE(A1,"-","")*1E6 + B1

= = = = = = =
HTH :>)
Dana DeLouis

On 3/21/2010 8:43 AM, 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!
>

First  |  Prev  | 
Pages: 1 2
Prev: Replace manual line breaks (Alt+Enter) with two spaces for selectedcells
Next: Pick numbers