Thread: Characters after the last space in a string
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
  
Posts: 153
Default Characters after the last space in a string
What excel formula (not VBA or macro) will give me the
characters after the last space in a string?

Something like this might work:
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",100)),100))
Reply With QuoteReply With Quote