Delete Spaces and Join Text in Cell

[Diggsy]

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

 

[RagDyer]

Try this:

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

--
HTH,

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

 

[Diggsy]

Thank You RagDyer. It works great

Chris

Try this:

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

--
HTH,

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

 

[RagDyer]

Thanks for the feed-back.