| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
