String of numbers

[Mia]

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!

 

[Barb Reinhardt]

You can start with this

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

 

[helene and gabor]

Hello Mia,

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

Jó szerencsét

Sebő Gábor

 

[Mia]

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:

 

[Mia]

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

 

[Rick Rothstein]

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")

 

[Dana DeLouis]

The result I want in Cell C1: 450001005975

Other ways as stated....

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

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