View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] gerry.lisa@gmail.com is offline
external usenet poster
 
Posts: 31
Default is there a quick way to do this besides cut and paste?

using XL 2003

I have 5 cells of addresss data (more than 100 times over)

A2 through A4
But the info that I want in A1 is in B1

Is there a quicker way than scrollling through the 650 record sheet
and cutting all the column B data into the column A cell??

I know I can type "=B2" in A1 but if I dragged that down, I would
lose data in column A.

....Lisa