| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing digits from one column to another
hello I have a spreadsheet which I would like to create a formula which will
take a 13 digit number and remove the first 7 digits and leave me with the last 5 digits of the number. Thanks in advance, Ryis |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing digits from one column to another
Assuming column A is the 13-digit number:
=RIGHT(A1,5) This takes only the five last digits of the number. -EW "Ryis" wrote: hello I have a spreadsheet which I would like to create a formula which will take a 13 digit number and remove the first 7 digits and leave me with the last 5 digits of the number. Thanks in advance, Ryis |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing digits from one column to another
Oh yeah, the 5-digit number column will be dependent upon the 13-digit number
column, so don't go deleting it. If you wanted to delete the 13-digit column, leaving the 5-digit column, you'd need to select the 5-digit column and then in another column Paste Special - Values. "Ryis" wrote: hello I have a spreadsheet which I would like to create a formula which will take a 13 digit number and remove the first 7 digits and leave me with the last 5 digits of the number. Thanks in advance, Ryis |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removing digits from one column to another
Thanks...that works great!!
"Ryis" wrote: hello I have a spreadsheet which I would like to create a formula which will take a 13 digit number and remove the first 7 digits and leave me with the last 5 digits of the number. Thanks in advance, Ryis |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
| Removing Digits | Excel Discussion (Misc queries) | |||
| Removing unwanted digits | Excel Discussion (Misc queries) | |||
| removing last 16 digits of the value of a cell | Excel Discussion (Misc queries) | |||
| Removing the last two digits of a cell | Excel Worksheet Functions | |||
Linear Mode
