Conditional formatting is for highlighting cells based on its contents.

You can strip traliling spaces by using TRIM function and h by using RIGHT,
LEFT or MID function, as appropriate.

"Johnnie" wrote:

Is it possible to set a conditional format in a worksheet so that when I copy
work from MS Project it automatically removes the trailing space and "h"?

I use MS Office 2003.

Thanks for your help.
Johnnie