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