I'm using excel 2007 so unfortunately the edit function is no more. Just to
clarify, the cell that i'm wishing to copy has half of the text formatted one
way and the other half formatted a different way. If anyone knows how to
conditionally format cells so anything after a "?" is formatted in a certain
way, that would also help solve the problem.

"JBeaucaire" wrote:

Give this a try:

Edit PasteSpecial Values and number formats
--
"Actually, I AM a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Brian" wrote:

What I'm trying to do is copy over the formatting that I've done to a cell
when I'm trying to use a relative reference to that cell. Aside from pasting
the format, is there some other way to copy the formatting as well as the
values within the cell?