View Single Post
  #2   Report Post  
Michael
 
Posts: n/a
Default

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