last ten digits
Try this:
--RIGHT(A1,10)
Format cell as:
type 0 then hold down <alt key and enter 0176 on the numeric key pad)
"Alok" wrote:
Martina
If the Cell with the data is A1 and there are always 10 numeric characters
at the end then you can use
=Right(A1,10)
"Martina" wrote:
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
|