Thread: replace last character in string
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
  
Posts: 117
Default replace last character in string
To replace last character in string called strTemp with a "G" use this

strTemp = Left(strTemp, Len(strTemp) - 1) & "G"

"ernie" wrote:

How can i replace last character in a string?
--
help a friend help you
Reply With QuoteReply With Quote