View Single Post
  #4   Report Post  
Ron Coderre
 
Posts: n/a
Default

Formula correction...

This may seem trivial, but SEARCH is not case sensitive, so the UPPER
function is not necessary:

=MID(A1,MIN(SEARCH({"0","1","2","3","4","5","6","7 ","8","9","A","B","C","D","E","F","G","H","I","J", "K","L","M","N","O","P","Q","R","S","T","U","V","W ","X","Y","Z"},A1&"0123456789ABCDEFGHIJKLMNOPQRSTU VWXYZ")),LEN(A1))
--
Regards,
Ron