not a very high tech way but ......

the find command so long as the 'match entire contents' box is not
ticked would not worry about the spaces.

eg if your cell you are copying is 'test ' on the other sheet if you
search for 'test' it should find all instances regardless of spaces.

also you have the chance to use the TRIM command, as it will strip the
spaces off the end of cells.

one thing to watch out for is if the second sheet you are looking on
has the word as the result of a formula as sometimes it searches the
formula code and not the results


--
lister_d_000169
------------------------------------------------------------------------
lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950
View this thread: http://www.excelforum.com/showthread...hreadid=548349