| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the last 7 characters of a no. to another column?
I need to get the last 7 characters of a number in one column to another
column so I can sort them. The number is in the format 00-1234-12. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get the last 7 characters of a no. to another column?
Is it a number, or is it a text string?
If the latter, try =RIGHT(A2,7) -- David Biddulph "Jennifer" <Jennifer @discussions.microsoft.com wrote in message ... I need to get the last 7 characters of a number in one column to another column so I can sort them. The number is in the format 00-1234-12. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get the last 7 characters of a no. to another column?
Hope your data is in text format and not formatted to display as 00-0000-00
format. If you mean to extract 1234-12 from 00-1234-12; try.. =RIGHT(A1,7) -- Jacob "Jennifer" wrote: I need to get the last 7 characters of a number in one column to another column so I can sort them. The number is in the format 00-1234-12. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set the number of characters in a column | Excel Discussion (Misc queries) | |||
| Set the number of characters in a column | Excel Discussion (Misc queries) | |||
| How do I cut column back to first 2 characters? Thanks | Excel Discussion (Misc queries) | |||
| Get max characters in cell in 1 column | Excel Discussion (Misc queries) | |||
| vlookup first 4 characters only in a column | Excel Discussion (Misc queries) | |||
Linear Mode
