Thread: last char of a string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark H. Shin Mark H. Shin is offline
external usenet poster
  
Posts: 13
Default last char of a string
myString = "abcdefg"

lastChar = Right(myString,1)

"Buddy Lee" wrote in message
...
how can I get the last char of a string?
e.g. "abcdefg" - last char is "g"
does excel know something like "txt[ Len(txt) ]"???

--

icq 25372592



Reply With QuoteReply With Quote