How to Substract a word from right side of the column using Ri
hi
if i want to retrieve more than one words
Eg: All names except last name?
Regards
"Mike H" wrote:
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
|