Let text in one cell overwrite the next cell

Question

Let text in one cell overwrite the next cell

Closed

Sofia - Jan 16, 2011 at 07:57 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- Jan 19, 2011 at 09:10 AM

Hi,

Does anyone know of a way to let the text in one cell overwrite the content of the cell to the right?

Explanation: When you have text in one cell and the cell next to that is empty the text is visible over the following cells. But if I have a formula in the neighbouring cell the text is only visible in the cell space even though nothing is visible in the neigbouring cell at the moment.
Can you get around this in some way? Like when you can choose bring forward for objects?

Very thankful for any help!

Let text in one cell overwrite the next cell
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
Excel if cell contains date then return value ✓ - Forum - Office Software
What values are possible for cells that contain numbers, dates and text? ✓ - Forum - Excel
Macro copy and paste in next blank cell - How-To - Excel
Google sheets if cell contains any text then ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Answer 1 · 2011-01-19T09:10:38-0500

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

768
Jan 19, 2011 at 09:10 AM

I am always reluctant to say no, but I would think that would not be possible. Since a formula can be any thing, like date or even a blank string, it will not be possible to say that "text" is visible or not. One way could be that you move formula to some other sheet or location or use some sort of macro to do that

Let text in one cell overwrite the next cell

1 reply

Your reply

Subscribe To Our Newsletter!