Formula to move data to another column

I would like to move data from one column to another. Is there a formula that can do that? I may append to existing data or replace it depending on options. If there's no formula, how can this be done manually? I tried cut/paste, but it did not work.Thank you.

Find more posts tagged with

Formulas

Comments

Shaine Greenwood

Hi Vlad,

At this time, a formula can't exist in the same cell as manually imputed data, and multiple formulas can't exist in the same cell.

That means that you CAN have a formula populate data in a cell based on conditions from other cells.

You CAN'T have a formula append a new value to existing data in a cell.

If you're wanting to cut/paste to append data together, you'll want to do this manually, and by double-clicking in the cell to expand it into edit mode. Keyboard shortcuts always work best when copying and pasting.