Delete Spaces and Join Text in Cell

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

Try this:

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

--
HTH,

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


"Diggsy" <[email protected]> wrote in message
news:[email protected]...
> 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

Thank You RagDyer. It works great

Chris

"RagDyer" wrote:

> Try this:
>
> =--SUBSTITUTE(A1," ","")
>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Diggsy" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>

Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Diggsy" <[email protected]> wrote in message
news:[email protected]...
> Thank You RagDyer. It works great
>
> Chris
>
> "RagDyer" wrote:
>
> > Try this:
> >
> > =--SUBSTITUTE(A1," ","")
> >
> > --
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> >
> > "Diggsy" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >