Thread: How to Substract a word from right side of the column using Right(
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How to Substract a word from right side of the column using Right(
Try this

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))

Mike

"JAF-In" wrote:

Hi
How can i remove a Right side word from a set of words in one column
i need to substract the last names in to another column
eg: James William Watson... In this case i need to to take" Watson to the
next column

Regards
Reply With QuoteReply With Quote