| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
deleting numbers in a column
:) :) can someone assist with the formula that would allow me to remove all but the last 4 digits in a column of numbers -- roddtx ------------------------------------------------------------------------ roddtx's Profile: http://www.excelforum.com/member.php...o&userid=32571 View this thread: http://www.excelforum.com/showthread...hreadid=523694 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
deleting numbers in a column
Hi
You could use a helper column with this in: =RIGHT(A2,4) and fill this down. Andy. "roddtx" wrote in message ... :) :) can someone assist with the formula that would allow me to remove all but the last 4 digits in a column of numbers -- roddtx ------------------------------------------------------------------------ roddtx's Profile: http://www.excelforum.com/member.php...o&userid=32571 View this thread: http://www.excelforum.com/showthread...hreadid=523694 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
deleting numbers in a column
you are the best :) Hi You could use a helper column with this in: =RIGHT(A2,4) and fill this down. Andy. "roddtx" wrote in message ... :) :) can someone assist with the formula that would allow me to remove all but the last 4 digits in a column of numbers -- roddtx ------------------------------------------------------------------------ roddtx's Profile: http://www.excelforum.com/member.php...o&userid=32571 View this thread: http://www.excelforum.com/showthread...hreadid=523694 -- roddtx ------------------------------------------------------------------------ roddtx's Profile: http://www.excelforum.com/member.php...o&userid=32571 View this thread: http://www.excelforum.com/showthread...hreadid=523694 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
deleting numbers in a column
Can we assume we are dealing with whole numbers?
=--RIGHT(A1,4) RIGHT returns text, the double negation turns this back to a number OR =MOD(A1,10000) Then copy either formula down the column. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "roddtx" wrote in message ... :) :) can someone assist with the formula that would allow me to remove all but the last 4 digits in a column of numbers -- roddtx ------------------------------------------------------------------------ roddtx's Profile: http://www.excelforum.com/member.php...o&userid=32571 View this thread: http://www.excelforum.com/showthread...hreadid=523694 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel ? Do Not Call Table | Excel Worksheet Functions | |||
| Consecutive Numbers down a column not to Exceed 49 | Excel Worksheet Functions | |||
| column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Add selected numbers in a column that are a different color | Excel Discussion (Misc queries) | |||
Hybrid Mode
