I have a cell that contains this:  00001/  /  /29100/  I would like 2 separate numeric cells, one cell that would contain 00001 and the second cell that contains 29100 omitting the slash marks completely.

Can this be done?  I don’t have much experience with Excel.  

Thank you for your help.

​I have a cell that contains this:  00001/  /  /29100/  I would like 2 separate numeric cells, one cell that would contain 00001 and the second cell that contains 29100 omitting the slash marks completely.Can this be done?  I don’t have much experience with Excel.   Thank you for your help.  Read More

​