Conditional Formatting

[Johnnie]

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

 

[Sheeloo]

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]

Sheeloo,
Thanks for the info.
Johnnie

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.