Retriving text from a column
Try
=TRIM(SUBSTITUTE(A1,TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)),))
If this post helps click Yes
---------------
Jacob Skaria
"JAF-In" wrote:
how can i retrieve text from one column to another except one last word
for eg:The text "how can i retrieve text from" is in column A1 and i have to
retrieve "how can i retrieve text" to B1
|