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

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

Thank you. Nice and simple, that's what I need.
regards
Martina

"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

Can I also ask what if I have to add a digit or a symbol onto the end of the
10 numbers. I can't get the symbol to show up here but it looks like a
degree sign (something unique to our university's database system). Anyway I
have the symbol, how do I add it on to the end of the ten digits.
kind regards
Martina



"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

Martina,
Use =Right(A1,10) & "*"
or whatever symbol you want.

"Martina" wrote:

Can I also ask what if I have to add a digit or a symbol onto the end of the
10 numbers. I can't get the symbol to show up here but it looks like a
degree sign (something unique to our university's database system). Anyway I
have the symbol, how do I add it on to the end of the ten digits.
kind regards
Martina



"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

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