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" 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

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" 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

Thanks for the feed-back.
--
Regards,

RD

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

"Diggsy" wrote in message
...
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" 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