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