Keep Dependent Value While Deleting Precedents

  • Thread starter Thread starter Atilla
  • Start date Start date
A

Atilla

Lets say I filled Column A with a bunch of data, but I only wanted the data
on every 2nd line, so I thought to myself... HMMM. Maybe I should set up a
pattern on colum B where I let cell B1=A2 and B2=A4 and B3=A6... and so I
allow this pattern to continue on. This works fantastically. All of a
sudden, column B contains ONLY the data I want. Unfortunately, since this
data in column B is going to be placed in a much larger, and much more
complicated spreadsheet to be used in other applications, I cannot leave
column A there to be cluttering it up. Also, I cannot have Column be simply
read =column A. Is there any way to keep the value I have just determined
for each cell in column B, and make it completely independent of what happens
to column A, or any other column, for that matter? A way of saving the data
that exists in the cells as their own independent values? If anyone can
help, I would appreciate it. Thanks.
 
Hi,

Copy column B then paste back over it with
Edit
PasteSpecial
select values
click OK

Mike
 
Atilla said:
Lets say I filled Column A with a bunch of data, but I only wanted the data
on every 2nd line, so I thought to myself... HMMM. Maybe I should set up a
pattern on colum B where I let cell B1=A2 and B2=A4 and B3=A6... and so I
allow this pattern to continue on. This works fantastically. All of a
sudden, column B contains ONLY the data I want. Unfortunately, since this
data in column B is going to be placed in a much larger, and much more
complicated spreadsheet to be used in other applications, I cannot leave
column A there to be cluttering it up. Also, I cannot have Column be simply
read =column A. Is there any way to keep the value I have just determined
for each cell in column B, and make it completely independent of what happens
to column A, or any other column, for that matter? A way of saving the data
that exists in the cells as their own independent values? If anyone can
help, I would appreciate it. Thanks.
Click to expand...


Look at "Replace a formula with its result" in the help file.
 
Back
Top