View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Add comma after last " in a cell

On Sat, 22 May 2010 12:12:59 -0400, "T. Valko" wrote:

Which is why I included a disclaimer:

This formula inserts a comma at the desired
location on the sample data you posted.


I saw the disclaimer. But I thought it would be beneficial to the OP to
understand that you were testing for the last digit in the string, and not for
the last " or ', and what the consequences might be.
--ron