Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
last ten digits
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
last ten digits
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
last ten digits
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
last ten digits
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count number of digits in a cell | Excel Worksheet Functions | |||
maximum number size/significant digits | Excel Discussion (Misc queries) | |||
Mistery digits on excel | Excel Discussion (Misc queries) | |||
excel floating digits error | Excel Discussion (Misc queries) | |||
Least number of digits in Y-axis labels | Charts and Charting in Excel |