last ten digits
Dear Experts,
I have a cell entry which is a mixture of text and numerical characters:
Jane Smith |jc122568|0295647894
I want to create a formula which will select only the last ten digits and
display them in another cell. How do I do this?
regards
Martina
|