Thread: last char of a string
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
  
Posts: 441
Default last char of a string
Hi,

Use "Right" as in:

sText = Right(YourString, 1)
MsgBox sText

HTH/

"Buddy Lee" wrote:

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