Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split or cut a value reverse trunc()???
Hello,
I have a list of numbers in one column that look like this 06-6102-00-5969 I want to write a formula in a separate column that will capture only the last 4 digits, 5969. I want to disregard, the first part of the number and only save the last 4, possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split or cut a value reverse trunc()???
if your column of numbers begin w/cell A1, then in an empty column
=RIGHT(A1, 4) Then copy down as far as necessary. If you need the values hardcoded so that you can delete the original data, select this new column and Copy, then click Edit/Paste Special, select Values. "Bobby" wrote: Hello, I have a list of numbers in one column that look like this 06-6102-00-5969 I want to write a formula in a separate column that will capture only the last 4 digits, 5969. I want to disregard, the first part of the number and only save the last 4, possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split cells below header column: | Excel Worksheet Functions | |||
Text to Columns - Only want to split SPECIFIC NUMBER of times | Excel Worksheet Functions | |||
Split Text | Excel Discussion (Misc queries) | |||
Killing the split window | Setting up and Configuration of Excel | |||
split combined Time Date cells | Excel Discussion (Misc queries) |