Thanks to both of you for posting suggestions and answers. This was very
helpful.
"Myrna Larson" wrote:
=MID(SUBSTITUTE(A1," ",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))),FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,255)
On Mon, 24 Jan 2005 09:49:02 -0800, "Michael"
wrote:
I need to find the last space from the right of text in a cell and then
return the text that is to the right of that last space.
Any help is greatly appreciated.
Thanks
|