Try this:

=--SUBSTITUTE(A1," ","")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Diggsy" wrote in message
...
I have a number(text value that I need to join in a cell.
It looks as follows. 087 56 2341. Is there a function or formula that
could
join them to look like 087562341. I would also like to remove the first
digit which is a zero or 0 character to look like 87562341. any
suggestions

Thanks

Chris