Thread: [Solved] Retrieve characters after nth occurence of a string
View Single Post
 
Old 06-16-2014, 03:41 PM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default
gebobs, the double minus signs (or double dashes) just replace a multiplication by one.
That way the formula just does the same:
=VALUE(RIGHT(A2,SUM(1*ISNUMBER(1*RIGHT(A2,COLUMN(INDIRECT("1:1")))))))
Last edited by whatsup; 06-16-2014 at 07:31 PM.
Reply With Quote