Excel formula to move certain fields
 

Have a large spreadsheet, need to move certain cells in one column to another
column. Column where data is has other information I do not wish to move.
Need a formula something like "if data in this cell, then move to"

Excel formula to move certain fields
 

So, you have data in column A and you want to move data to Column C if the
value =x?

In Cell C 2 put =If (A2="X",A2," ")

"kimtruss" wrote:

Have a large spreadsheet, need to move certain cells in one column to another
column. Column where data is has other information I do not wish to move.
Need a formula something like "if data in this cell, then move to"

Excel formula to move certain fields
 

Have entered this formula, but does not work. I want the data in column a to
move to column c regardless of what the cell content of column a is. Any
ideas?

"PAR" wrote:

So, you have data in column A and you want to move data to Column C if the
value =x?

In Cell C 2 put =If (A2="X",A2," ")

"kimtruss" wrote:

Have a large spreadsheet, need to move certain cells in one column to another
column. Column where data is has other information I do not wish to move.
Need a formula something like "if data in this cell, then move to"

Excel formula to move certain fields
 

Can you be more specific about your table set up and what you are trying to
accomplish? If you want to move data, you can cut and then insert cut cells.
Or, have enter =A2 in cell C2.



"kimtruss" wrote:

Have entered this formula, but does not work. I want the data in column a to
move to column c regardless of what the cell content of column a is. Any
ideas?

"PAR" wrote:

So, you have data in column A and you want to move data to Column C if the
value =x?

In Cell C 2 put =If (A2="X",A2," ")

"kimtruss" wrote:

Have a large spreadsheet, need to move certain cells in one column to another
column. Column where data is has other information I do not wish to move.
Need a formula something like "if data in this cell, then move to"

Excel formula to move certain fields
 

Formulas cannot "move" data.

Formulas can only return results into the cell(s) in which they are written.

To move data you would require VBA code, either event code or a macro routine.


Gord Dibben MS Excel MVP

On Thu, 20 Apr 2006 20:11:01 -0700, kimtruss
wrote:

Have entered this formula, but does not work. I want the data in column a to
move to column c regardless of what the cell content of column a is. Any
ideas?

"PAR" wrote:

So, you have data in column A and you want to move data to Column C if the
value =x?

In Cell C 2 put =If (A2="X",A2," ")

"kimtruss" wrote:

Have a large spreadsheet, need to move certain cells in one column to another
column. Column where data is has other information I do not wish to move.
Need a formula something like "if data in this cell, then move to"