Thread: left or right
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antonov Antonov is offline
external usenet poster
 
Posts: 44
Default 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