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

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.

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