String of numbers

  • Thread starter Thread starter Mia
  • Start date Start date
M

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!
 
Hello Mia,

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

Jó szerencsét

Sebő Gábor
 
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:
 
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
Click to expand...
 
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")
 
The result I want in Cell C1: 450001005975

Other ways as stated....

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

= = = = = = =
HTH :>)
Dana DeLouis
 
Back
Top