Thread: Removing 2-3 characters at the end
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ty Ty is offline
external usenet poster
  
Posts: 72
Default Removing 2-3 characters at the end
On Jun 8, 4:28*pm, "Rick Rothstein"
wrote:
Give this formula a try...

=LOOKUP(9E+99,--LEFT(SUBSTITUTE(MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8 ,9},A1&"0*123456789")),LEN(A1)),".",""),ROW(INDIRE CT("1:99"))))

Rick Rothstein (MVP - Excel)

Thank you! It works.
Reply With QuoteReply With Quote