Retriving text from a column
You right, because I was removing spaces with the inner part of the formula
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))
I never realised I would get the last space back when using the extracted
string in the outer substitute part, nice spot.
Mike
"Rick Rothstein" wrote:
Try this
=SUBSTITUTE(A1,),"")
You should encase that in a TRIM function in order to get rid of the space
that is in front of that last word...
=TRIM(SUBSTITUTE(A1,TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)),""))
--
Rick (MVP - Excel)
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
|