| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
left or right
hello there, say I have a cell with a 8 digits number in it (i.e. 54789621).
In another cell I need to have only the 4th digit (8). Is it possible? And also: is it possible to sort the data in a column by taking the 5th digit of each number? thanks for your precious help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
left or right
"antonov" wrote in message ... hello there, say I have a cell with a 8 digits number in it (i.e. 54789621). In another cell I need to have only the 4th digit (8). Is it possible? =mid(A1,4,1) And also: is it possible to sort the data in a column by taking the 5th digit of each number? thanks for your precious help in a helper column add =LEFT(A1,4)&RIGHT(A1,3) and then sort by the helper column. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
left or right
Range("B1") = Mid(Range("A1"), 4, 1)
and yes just make an intermediate col with the same statement as above, replacing the 4 with a 5 and sort on that column Ron "antonov" wrote: hello there, say I have a cell with a 8 digits number in it (i.e. 54789621). In another cell I need to have only the 4th digit (8). Is it possible? And also: is it possible to sort the data in a column by taking the 5th digit of each number? thanks for your precious help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LEFT function-all to left of a comma? | Excel Worksheet Functions | |||
| when inserting new worksheets they read right to left not left to. | Setting up and Configuration of Excel | |||
| My Excel view is Right to Left instead of Left to Right !!! | Excel Discussion (Misc queries) | |||
| Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
| How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) | |||
Linear Mode
