View Single Post
  #5  
Old 17th March 2013, 11:04 AM
aussielongboat aussielongboat is offline
Member
 
Join Date: Nov 2010
Posts: 259
Default

even tidier:

b3= 1356
c3= =iferror(MID(B3,LEN(B3),1),"") etc

d3= =MID(B3,LEN(B3)-1,1)
e3= =MID(B3,LEN(B3)-2,1)
f3= =MID(B3,LEN(B3)-3,1)
Reply With Quote