How to successfully delete formula dependent columns

DataMaster

New Member
Joined
Oct 26, 2016
Messages
2
Hi!

I am having trouble with cleaning up my data after running analysis on my excel files. I have an excel file where I had to separate a "Name" column into "First" & "Last" name columns. I did this successfully, but now I want to delete the original "Name" column, but I am having trouble figuring out how to do this correctly. I tried turning the "Calculations" to manual, but when I saved the file, the formulas were re-calculated & turned the data into error msgs. I'd like to delete the old data files as I would like to export the file into our CRM system with the corrected information/formatting.

I am having similar trouble with another excel file with more advanced "VLOOKUPs" and "IF" formulas.

Any help would be much appreciated!

Best!
Yuliya
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Mick Peters

Board Regular
Joined
May 18, 2015
Messages
93
Hi Datamaster,
The easiest way I can think of doing this if it is a one off is to copy the new data and then paste special as values into the same place. The data will be saved and the old data can be removed.
I recommend saving a back up prior to doing this so you can go back if the results are not as you want or expect.
I hope this helps
Mick.
 

Forum statistics

Threads
1,147,743
Messages
5,742,935
Members
423,765
Latest member
PaulD1984

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top