Thread: replace last character in string
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default replace last character in string
This is one way...

StrVariable = Left(StrVariable, Len(StrVariable) - 1) & YourNewCharacter

--
Rick (MVP - Excel)


"ernie" wrote in message
...
How can i replace last character in a string?
--
help a friend help you

Reply With QuoteReply With Quote