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