Move data from one column to another

  • Thread starter Thread starter Denise Posey
  • Start date Start date
D

Denise Posey

I am using Excel 2002 and I am trying to move data from
one column into another. The column I want to move data
from does not have data in every cell. I only want to
move the "non blank" cells.

For Example: If cell B2 has text/number, move to cell A2

A B C D
Dallas TX 75252
Plano TX 75075
McKinney TX 75070

I tried using the "=CellToRight" Name-Define function but
it wasn't working properly. I even tried to create a
macro, but it only worked for that cell.

Any help is greatly appreciated!
Denise Posey
 
Hi
I'm not so sure what you're trying to achive. You may post an example
of the source data and the expected result
 
To do this manually (you can record a macro as you do this),

Select the range of cells that you want to compress
Choose Edit>Go To
Click the Special button
Choose Blanks, click OK
Choose Edit>Delete
Select 'Shift Cells left', click OK
 
A B
TX 78852-3929
TX 78852-5007
TX 77437-5430
TX 78834-3003
TX 78834-3709
78722-1944
TX 77571-5532
TX 77571-5510
TX 78852-4236
77009-4638
TX 78250-2109
77705-1804
TX 78207-4631
77598-3106
TX 77587-4352

I only want to move the cells that have zipcodes in them
from column B to column A (over-writing TX). Ignoring any
blank cells in column B.

I am using Excel 2002 on Windows XP
 
Debra,

I tried this the first time but a little differently.
When I follow you steps and get to 'Shift Cells left' it
didn't do anything. Can you think of what I am doing
wrong. I'm not sure if I explained myself well enough in
the first posting, but what I want to do is move
everything from a particular column and ignore any blank
cells.

Thanks again,
Denise
 
I misunderstood your goal. Try the following on a copy of your data:

Select column B
Choose Edit>Copy
Select Column A
Choose Edit>Paste Special
Select 'Skip blanks', click OK
Select column B
Press the Delete key
 
Perfect!!! Thanks again. I hate when it's right at your
fingertip, but just can't remember what to do!
 
Back
Top