Thank you for responding, unfortunately I actually need the text to come out of the one cell and be set as the value in the new cell. For instance: Cell X "The big brown dog" Cell Y "jumps over the fence". When you use the wrap text feature Cell X has a value of: "The big brown dog jumps over the fence"