concatenate num

I want to merge these two figures
I use Office 2003

Hi,

One possible solution!
I was inspired here: http://www.excelfox.com/forum/f13/ex...eric-text-186/

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,CH AR(160),""),"0000")

Thank you fantastic