Thread: Cut and Paste Problem

Hi everyone,



I have a problem with my excel, the problem is with cutting a portion of a multi-word cell and pasting it into another cell. The Pasted part splits the words into separate cells rather than putting all the cut words into a single destination cell. Hope someone out there can help me with this problem.


Ferdie

I'd like more information;
How are you cutting a portion of a cell; highlighting and cutting from the formula bar?

and
How are you pasting it into the next cell and is there data in there already?

ChemistB

Originally Posted by ChemistB

I'd like more information;
How are you cutting a portion of a cell; highlighting and cutting from the formula bar?

and
How are you pasting it into the next cell and is there data in there already?

ChemistB

I cut a portion of a cell by highlighting and cutting (ctrl x) in the formula bar and pasting it (ctrl v) on the next cell. there is no data on that cell.

Ferdie

Hi Harry,

Yeah that works for few cells but the problems is when I try to paste the words it automatically distributed to every cells instead of just one cell where all the words fit in. It there any setting or options that need to be change here?

Ferdie

Originally Posted by harrywaldron

Hi Ferdie - Copy/Paste won't take multiple columns and automatically combine them as it'll take the A/B cells and make C/D cells (if "C" is the blank target). You might try the following idea of combining cells by formula:

How to combine 2 cells into one:

Presuming the two columns you want to combine are A and B and they are on the 1st row, put this in cell C1, and copy it down the length of your data

With a space
=A1&" "&B1

With no spaces
=A1&""&B1

Combine 3 Cells with no spaces
=A1&""&B1&""&C1