Thread: Extract data to the right of the last comma in a cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Paul D. Simon Paul D. Simon is offline
external usenet poster
  
Posts: 46
Default Extract data to the right of the last comma in a cell
Here's a regular (non array) formula solution to extract data to the
right of the last comma in a cell:

=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1,",","*",LEN(A1)-LEN(SUBSTITUTE
(A1,",","")))))
Reply With QuoteReply With Quote