concatenate num

[mahmoud-lee]

I want to merge these two figures
I use Office 2003

[PcMax]

Hi,

One possible solution!
I was inspired here: http://www.excelfox.com/forum/f13/extract-number-from-alphanumeric-text-186/

[Excel Fox]

Good thinking PcMax. That would be especially helpful if there are other non-numeric characters also.

If there's only going to be as it is now (with that one non-printable character having ascii code 160), then you could also use a simple substitution

=SUBSTITUTE(A2,CHAR(160),"")&TEXT(SUBSTITUTE(B2,CHAR(160),""),"0000")

[mahmoud-lee]

Thank you fantastic