Thread: [Solved] Retrieve characters after nth occurence of a string
View Single Post
 
Old 06-13-2014, 12:36 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
Paul, wondering if there's a shorter way?

If it's just about to separate numbers from text on the right side:
=VALUE(RIGHT(A2,SUM(--ISNUMBER(--RIGHT(A2,COLUMN(INDIRECT("1:1")))))))
Change the function RIGHT to LEFT to separate numeric parts on the left side of text.

Edit: Of course it's an arrayformula as well
Reply With Quote