Thread: read characters starting from the right until a space is reached
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary Brown
 
Posts: n/a
Default read characters starting from the right until a space is reached

Assuming that the text will never use the character "^", then use the
following formula:-

=RIGHT(A1,LEN(A1)-FIND("^",SUBSTITUTE(A1,"
","^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))),1))

If "^" is used replace it with a character that will never appear e.g.
¬ or ¦


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=497953

Reply With QuoteReply With Quote