Thread: How to trim a string to the last "."
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default How to trim a string to the last "."
Hello,

You already got some solutions, but just for the fun of it:
=regexpreplace(A1,"^(.*\.)?.*$","$1")

This UDF you can get he
http://www.sulprobil.com/html/regexp.html

Regards,
Bernd
Reply With QuoteReply With Quote