Sounds like you need the InStrRev() function. It finds the LAST instance of a
search string within a source string, but the return value is relative to the
regular order.

strC = "Names Places Cities"

intRev = InStrRev(strC,"")

strLast = Trim(Mid(strC,intRev + 1))

Range("D3").Value = strLast
--
Hmm...they have the Internet on COMPUTERS now!


"Jim Jackson" wrote:

I have a column which contains data separated by " " in two or more
locations within each cell. I need to paste the farthest right data into
another cell.

Example: Names Places Cities etc.

I have searched the Posts her for an idea but nothing gets the desired
result. I have even tried replacing " " with " " but there still are two
or more of these.

Any ideas would be greatly appreciated.

--
Best wishes,

Jim